Summing up data from groups & pasting it another column
Solved/Closed
V1R4L
Posts
3
Registration date
Tuesday 12 March 2013
Status
Member
Last seen
12 March 2013
-
12 Mar 2013 à 04:58
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 Mar 2013 à 06:36
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 Mar 2013 à 06:36
Related:
- Summing up data from groups & pasting it another column
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- Tmobile data check - Guide
- Export data from excel - Guide
- Excel column number - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
12 Mar 2013 à 11:34
12 Mar 2013 à 11:34
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),"")
12 Mar 2013 à 22:41
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);)
13 Mar 2013 à 06:36