Creating IF statement to filter and ADD.

Solved/Closed
Report
Posts
3
Registration date
Thursday April 8, 2010
Status
Member
Last seen
April 8, 2010
-
Posts
3
Registration date
Thursday April 8, 2010
Status
Member
Last seen
April 8, 2010
-
HI,

i am trying to create an IF statement to filter a row and then add the numbers in another row on those filters.

so for example

AA 12
BB 11
AA 12
AA 12
BB 11
BB 11

i need the result of just AA and BB on there own, so it would show as

AA = 36
BB = 33

Hope someone can help

thanks

Saqib :)

1 reply

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
489
Hello,

To AA = 36

use this formula : =SUMIF(A:A,"AA",B:B)

To BB = 33
use this formula : =SUMIF(A:A,"BB",B:B)

Best regards
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
3
Registration date
Thursday April 8, 2010
Status
Member
Last seen
April 8, 2010

Genius!

thanks you so much!

One more question if i wanted to point to data in another tab how do i do that?

thanks again for your help very much appreciated.


Saqib
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
489
For exemple, I supposed data are on sheet1 and formula on sheet2 then the formula become :

To AA = 36
=SUMIF(Sheet1!A:A,"AA",Sheet1!B:B)


Do same thing for BB

See you
Posts
3
Registration date
Thursday April 8, 2010
Status
Member
Last seen
April 8, 2010

Got it thanks :)