Previous Topic Next Topic

Creating IF statement to filter and ADD.

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

Answer 1 / 1
aquarelle Posts 7435 Status Moderator 491
Apr 8, 2010 at 06:34 AM
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 April 8, 2010 Status Member Last seen April 8, 2010
Apr 8, 2010 at 08:52 AM
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 7435 Status Moderator 491
Apr 8, 2010 at 09:02 AM
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 April 8, 2010 Status Member Last seen April 8, 2010
Apr 8, 2010 at 09:06 AM
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