Sum if value above is X
 

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



--
Thank you
Neil

Sum if value above is X
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Neil" wrote in message
...
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



--
Thank you
Neil

Sum if value above is X
 

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

Sum if value above is X
 

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


"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Neil" wrote in message
...
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



--
Thank you
Neil

Sum if value above is X
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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


"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Neil" wrote in message
...
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



--
Thank you
Neil