Formula help with greater than and count if

J

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
 
J

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,B2:D2)


OR

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


If this post helps click Yes
 

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

Similar Threads


Top