Sum if value above is X

N

Neil

Hi All
I am having trouble writing a formula to Sum the value of row 3 if the Cell
above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the
Sum of all of row 3 with an X above is only 350...?
Im sure there is a simple formula out there.....

A B C D E F G
1WK 46 47 48 49 50 51 52
2 X X X X
3 149 162 128 88 94 87 81
2 = 350
3 = 788
 
S

smartin

Neil said:
Hi All
I am having trouble writing a formula to Sum the value of row 3 if the Cell
above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the
Sum of all of row 3 with an X above is only 350...?
Im sure there is a simple formula out there.....

A B C D E F G
1WK 46 47 48 49 50 51 52
2 X X X X
3 149 162 128 88 94 87 81
2 = 350
3 = 788

=SUMIF($B$3:$H$3,"X",$B$4:$H$4)
 
T

T. Valko

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Neil said:
MVP is right.
It worked a like a dream and simple thanks for the help....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top