Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif, multiple criteria
Hi all,
I'd really appreciate help with what is, I'm sure, a simple problem that I'm too stupid to solve! The problem - Using COUNTIF (I think), the problem is that it requires two criteria/conditions to be met: For the range to be counted (as 1, NOT 2), A1 must have a value of 0 AND B1 must be more than 1. ONLY if these conditions are meet should the range be counted as 1. Eagerly awaiting for reply, JS25 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif with multiple criteria | Excel Worksheet Functions | |||
Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
COUNTIF - Multiple Criteria | Excel Worksheet Functions | |||
Countif for multiple criteria | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |