D
Dan Shoemaker
I would like to know how to count if 2 criterea are true in a range of cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
=SUMPRODUCT(--(rng1="text"),--(rng2=number))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
cellsDan Shoemaker said:I would like to know how to count if 2 criterea are true in a range of
D
Dan Shoemaker
TY
Bob Phillips said:=SUMPRODUCT(--(rng1="text"),--(rng2=number))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
cells
J
Jman
Dan Shoemaker said:
R
Roger Govier
Hi
Continuing with what Bob told you, you can add as many criteria as you
wish
=SUMPRODUCT(--(rng1="text"),--(rng2=number),--(rng3=number),--(rng4="text"))
Each test will return True or False.
The double unary minus will coerce True's to 1's and False's to 0's.
Multiplying them together, it is only all 1's that will return a value
of 1, any 0 will make the whole sum 0.
So Sumproduct is adding only the values where all tests are true, and
therefore giving your Count.
Continuing with what Bob told you, you can add as many criteria as you
wish
=SUMPRODUCT(--(rng1="text"),--(rng2=number),--(rng3=number),--(rng4="text"))
Each test will return True or False.
The double unary minus will coerce True's to 1's and False's to 0's.
Multiplying them together, it is only all 1's that will return a value
of 1, any 0 will make the whole sum 0.
So Sumproduct is adding only the values where all tests are true, and
therefore giving your Count.