ExcelBanter - countif with multiple conditions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif with multiple conditions (https://www.excelbanter.com/excel-worksheet-functions/222343-countif-multiple-conditions.html)

Chad Portman

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.

Ron@Buy

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.

T. Valko

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.

All times are GMT +1. The time now is 10:38 AM.