Previous Topic Next Topic

Creating IF statement to filter and ADD.

Solved/Closed
saqib786 Posts 3 Registration date Thursday 8 April 2010 Status Member Last seen 8 April 2010 - 8 Apr 2010 à 06:00
saqib786 Posts 3 Registration date Thursday 8 April 2010 Status Member Last seen 8 April 2010 - 8 Apr 2010 à 09:06
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 :)

Related:

1 response

Réponse 1 / 1
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 491
8 Apr 2010 à 06:34
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
saqib786 Posts 3 Registration date Thursday 8 April 2010 Status Member Last seen 8 April 2010
8 Apr 2010 à 08:52
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
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 491
8 Apr 2010 à 09:02
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
saqib786 Posts 3 Registration date Thursday 8 April 2010 Status Member Last seen 8 April 2010
8 Apr 2010 à 09:06
Got it thanks :)

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
Do users get notified when I add them to a group?
maicart -
dwebb -

2 responses