Sum if value above is X

[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

 

[T. Valko]

Try this:

=SUMIF(A2:G2,"X",A3:G3)

 

[smartin]

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)

 

[Neil]

MVP is right.
It worked a like a dream and simple thanks for the help....
--
Thank you
Neil

Try this:

=SUMIF(A2:G2,"X",A3:G3)

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

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