Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function
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) Hope this makes sense. I'm sure it's something simple, but I can't figure it out. Thanks again! Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
countif function | Excel Worksheet Functions | |||
COUNTIF Function | Excel Discussion (Misc queries) |