Hi Jaglag!
You could use:
=COUNTIF(A1:A10,">"&50)-COUNTIF(A1:A10,">="&100)
Not that with the above, donations of exactly 50 and 100 will not be
counted.
Or you can use:
=SUMPRODUCT(--(A1:A10>50),--(A1:A10<100))
The (A1:A10>50) bit is an implicit IF statement that returns TRUE or
FALSE
The -- coerce the returns of TRUE and FALSE to 1 and 0
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Jaglag said:
countif # >50 and <100 (how do I write this???) I have 10
differant brackets to calculate. Need to know the number of people
out of 500 that donated what amounts.
