Help needed adding third If
Hi,
A few notes: if the entry in column A is the number 1 some of the
suggestions will fail, so you must adjust them by removing the "".
Similarly, if the entry is text in column A test for A=1 will fail, so you
must adjust the formulas by adding "1".
Just to be cute, the following formula deals with both text or number
=SUMPRODUCT(--(D2:D11996&A2:A11996&E2:E11996="X1S"))
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"lakwriter" wrote:
Hello all, I am having difficulty integrating a third condition into a
complex IF statement.
I have data on one worksheet and my table with formulas on a separate
worksheet.
I want to know how many records (2:1996) have a value of "S" when column
A="1" AND column D="X".
I can check for one value using the formula
=SUM(IF(Cleaned!D2:D11996="x",IF(Cleaned!H2:H11996 ="S",1,0),0))
But I cannot figure out how to make it check both columns before totaling
the frequency of "s".
Any help is greatly appreciated.
Leslie
|