Formula help with greater than and count if
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 |
Formula help with greater than and count if
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 --------------- Jacob Skaria "Jeremy" wrote: 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 |
All times are GMT +1. The time now is 03:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com