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

aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 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 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 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 :)