Nested Functions and/or DCOUNT

[Amanda_Guenthner]

Need to get count for multiple conditions - can u do mutually exclusive count
in nested fx? Need to determine how to get count for all instances "x" in
column A, where column B, C, or D = a number. Tried this:
=IF(COUNTIF(N17:N26,"Pre-Qualification"),(COUNTIF(J17:L27,"X"))); but not
mutually exclusive. Thanks in advance for help!

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100="X"),--((B1:B100=number)+(C1:C100=number)+(D11
00=number)>0))

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
news:[email protected]...