ExcelBanter - Count If Formula for multiple conditions?? How To??

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

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

- - Count If Formula for multiple conditions?? How To?? (https://www.excelbanter.com/excel-worksheet-functions/7519-count-if-formula-multiple-conditions-how.html)

LPrain

Count If Formula for multiple conditions?? How To??

How do I create a countif formula for multiple
conditions? I have a spreadsheet with two
colums: "agents name" and "rental or sale". I want to
create a formula that will count if the agents name
= "Linda" in column 1 and "rental" in column 2.

Any ideas?

Frank Kabel

Hi
use SUMPRODUCT.
=SUMPRODUCT(--(A1:A100="Linda"),--(B1:B100="rental"))

See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Frank Kabel
Frankfurt, Germany

"LPrain" schrieb im Newsbeitrag
...
How do I create a countif formula for multiple
conditions? I have a spreadsheet with two
colums: "agents name" and "rental or sale". I want to
create a formula that will count if the agents name
= "Linda" in column 1 and "rental" in column 2.

Any ideas?

All times are GMT +1. The time now is 05:49 PM.