Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count of Number Values Greater Than, Less Than | Excel Worksheet Functions | |||
Looking to count using a greater-than | Excel Discussion (Misc queries) | |||
Count non-contiguous cells where value is greater than 0 | Excel Worksheet Functions | |||
How do I count numbers in a range that are greater than and less . | Excel Worksheet Functions | |||
count TIME that is GREATER than 24 hours | Excel Worksheet Functions |