Summing up data from groups & pasting it another column
Solved/Closed
V1R4L
Posts
3
Registration date
Tuesday March 12, 2013
Status
Member
Last seen
March 12, 2013
-
Mar 12, 2013 at 04:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 13, 2013 at 06:36 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 13, 2013 at 06:36 AM
Related:
- Summing up data from groups & pasting it another column
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Display two columns in data validation list but return only one - Guide
- Auto serial number in excel based on another column ✓ - Excel Forum
- How to be offline in whatsapp when data is on - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 12, 2013 at 11:34 AM
Mar 12, 2013 at 11:34 AM
let say
your letters are in column A, starting from row 1
and your numbers are in column B, starting from row 1
and you want sum to show in column C, then use this in cell C1 and copy down
=IF(COUNTIF(A:A,A1)=COUNTIF(A$1:A1,A1),SUMIF(A:A,A1,B:B),"")
your letters are in column A, starting from row 1
and your numbers are in column B, starting from row 1
and you want sum to show in column C, then use this in cell C1 and copy down
=IF(COUNTIF(A:A,A1)=COUNTIF(A$1:A1,A1),SUMIF(A:A,A1,B:B),"")
Mar 12, 2013 at 10:41 PM
This made my day way easyer, thank you so much!
Edit: the code that worked for me was: =IF(COUNTIF(A:A;A1)=COUNTIF(A$1:A1;A1);SUMIF(A:A;A1;B:B);)
Mar 13, 2013 at 06:36 AM