| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula to evaluate multiple criteria (countif + and)
I am trying to evaluate a data base of customers where column A lists the
customers by name, column B is annualized sales $, and column C is the manhours of service per year spent on that account. I want to know how many customers I have which generated less than $100,000 of sales, and which required more than 100 manhours of service. I have tried every variation of "Countif " combined with "and" that I can think of , for example: =countif(and(b1:b100,"<"&100000),(c1:c100,""&100) ) This is a simplified example, but this is the solution I need. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| Excel: Using DSUM, I need to evaluate 2 criteria that are not toge | Excel Worksheet Functions | |||
| How do I COUNTIF in excel using multiple criteria? | Excel Worksheet Functions | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
