Data ranges within a column
Try this:
F15: =SUMPRODUCT((D15:D830=1)*(D15:D830<=999))
F16: =SUMPRODUCT((D15:D830=1000)*(D15:D830<=2499))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"JT" wrote:
Range D15 through D830 contains numbers of various numeric values. In column
F15 I want to report the total number of entries in D15 through D830 that
fall within certain parameters, ie...all of the numbers that fall between 1
and 999. In F15 I want to report all ov the numbers that fall between 1000
and 2499, etc....
Is this a VLOOKUP function and how do I arrange it to properly report?
Thanks!
Jack
|