ExcelBanter - Formula format for Count or Countif funtion with two criterias

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

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

- - Formula format for Count or Countif funtion with two criterias (https://www.excelbanter.com/excel-worksheet-functions/47269-formula-format-count-countif-funtion-two-criterias.html)

Debi

Formula format for Count or Countif funtion with two criterias

What would be the formula specifics when I want to use the count or countif
funtion with two criteria. Example:
Count A1:A5 and c1:c5
countif A1:A5 equals f and D1:D5 equals h
Countif A1:A5 equals f and count D1:D5

David Billigmeier

=COUNT(A1:A5)+COUNT(C1:C5)
=SUMPRODUCT(--(A1:A5="f"),--(D1:D5="h"))
=SUMPRODUCT(--(A1:A5="f"),--(D1:D5<""))

--
Regards,
Dave

"Debi" wrote:

What would be the formula specifics when I want to use the count or countif
funtion with two criteria. Example:
Count A1:A5 and c1:c5
countif A1:A5 equals f and D1:D5 equals h
Countif A1:A5 equals f and count D1:D5

Myrna Larson

For COUNT, you can use a single formula, as it accepts multiple ranges, i.e.

=COUNT(A1:A5,C1:C5)

On Mon, 26 Sep 2005 11:01:04 -0700, "Debi"
wrote:

What would be the formula specifics when I want to use the count or countif
funtion with two criteria. Example:
Count A1:A5 and c1:c5
countif A1:A5 equals f and D1:D5 equals h
Countif A1:A5 equals f and count D1:D5

All times are GMT +1. The time now is 09:50 AM.