Formula help with greater than and count if

[Jeremy]

I am looking for a way to formulate in A2:A4 so it counts B to D in the same
row if B1 is greater than A1 and the same for C and D. Below is a example of
before and after.

Thank you


Before
A B C D
1 7/31/09 3/2/09 4/13/09 8/1/09
2 10 9 8
3 5 10 15
4 20 25 30

After
A B C D
1 7/31/09 3/2/09 4/13/09 8/1/09
2 19 10 9 8
3 15 5 10 15
4 45 20 25 30

 

[Jacob Skaria]

you have mentioned greater than but your answers display the results for less
than.

in A2 and copy down as required
=SUMIF($B$1:$D$1,"<"&$A$1,B22)


OR

=SUMIF($B$1:$D$1,">"&$A$1,B22)
(as per your requirement)


If this post helps click Yes