Thread
:
COUNTIF Function
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
external usenet poster
Posts: 4,624
COUNTIF Function
????
In article ,
"Don Guillett" wrote:
try this idea
=sumproduct((a2:a22=0)*(a2:a22<21))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"mpenkala" wrote in message
...
Hi, I'm having a few problems with the COUNTIF function. This is what I'm
looking for.
Range is A40:A70. This contains numbers between 0 and 21.
Then I have columns B,C,D
In columnB I would like to have COUNTIF(A40:A70, odd number) (So count all
odd number's in the range except for 0)
In columnC I would like to have COUNTIF(A40:A70, 12 AND <21) (So count
all
numbers between 12 and 21)
In columnD I would like to have COUNTIF(A40:A70, 1,4,7,13,19) (So count
all
numbers I've requested)
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey