ExcelBanter - Count if multiple variable exist

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

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

- - Count if multiple variable exist (https://www.excelbanter.com/excel-discussion-misc-queries/135170-count-if-multiple-variable-exist.html)

Stan

Count if multiple variable exist

I'm trying to count cells if muplite variable exist. For example, I want to
count if a range of cells is 0 or <500. I've tried COUNTIFS but I'm on
Excel 2003 and it doesn't like it. I guess it's for Office 2007. Can
someone tell me how to write a fuction either standard or nested that would
perform this count?

Many thanks if you can help!!

Teethless mama

Count if multiple variable exist

COUNTIFS function is use for XL2007

=COUNTIF(A1:A100,"0")-COUNTIF(A1:A100,"=500")
or
=SUMPRODUCT(--(A1:A1000),--(A1:A100<500))

"Stan" wrote:

I'm trying to count cells if muplite variable exist. For example, I want to
count if a range of cells is 0 or <500. I've tried COUNTIFS but I'm on
Excel 2003 and it doesn't like it. I guess it's for Office 2007. Can
someone tell me how to write a fuction either standard or nested that would
perform this count?

Many thanks if you can help!!

All times are GMT +1. The time now is 01:35 AM.