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
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
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.
