ExcelBanter - countif function with multiple criteria

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countif function with multiple criteria (https://www.excelbanter.com/excel-discussion-misc-queries/40024-countif-function-multiple-criteria.html)

Geoff

countif function with multiple criteria

Is it possible to have multiple criteria for a countif function?
Thanks.

Bob Phillips

Not COUNTIF, but SUMPRODCT will

=SUMPRODUCT(--(rng1="value1"),--(rng2=num2))

rng1 and rng2 must be the same size, and cannot be complete columns.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Geoff" wrote in message
ups.com...
Is it possible to have multiple criteria for a countif function?
Thanks.

All times are GMT +1. The time now is 04:39 AM.