| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif with multiple conditions
I have a list of data in coloumns A and B. I need to write a countif style
formula for if column A has one set of data in it while at the same time column B has another set of data. So it should only count if the conditions for column A and the conditions in column B are met. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif with multiple conditions
Try:
=SUMPRODUCT(--(A1:A1000="your condition"),--(B1:B1000="your condition")) "Chad Portman" wrote: I have a list of data in coloumns A and B. I need to write a countif style formula for if column A has one set of data in it while at the same time column B has another set of data. So it should only count if the conditions for column A and the conditions in column B are met. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif with multiple conditions
see your other post
-- Biff Microsoft Excel MVP "Chad Portman" wrote in message ... I have a list of data in coloumns A and B. I need to write a countif style formula for if column A has one set of data in it while at the same time column B has another set of data. So it should only count if the conditions for column A and the conditions in column B are met. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif with multiple conditions | Excel Discussion (Misc queries) | |||
| Countif with multiple conditions | Excel Discussion (Misc queries) | |||
| countif-multiple conditions | Excel Discussion (Misc queries) | |||
| COUNTIF Multiple Conditions | Excel Discussion (Misc queries) | |||
| COUNTIF using multiple conditions? | New Users to Excel | |||
Linear Mode
