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