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 :)

1 response

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 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
1
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
0
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 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
0
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 :)
0