A
Alan Bernardo
Here's something simple that I can't figure.
Say I want to look in a cell and if either of two things appear, I want to
count the cell.
Here's the formula, with the touchy part toward the end:
=SUMPRODUCT(--(D1229:H12:H29:M12:M29:Q12:Q20="D1"),--(G12:G29:K12:K291229:T12:T29="FW""G"))/J34
There at the end, the way it goes, the cell is counted only if an "FW" and a
"G" is present. I want it to be an "FW" OR a "G".
Thanks,
Alanb
Say I want to look in a cell and if either of two things appear, I want to
count the cell.
Here's the formula, with the touchy part toward the end:
=SUMPRODUCT(--(D1229:H12:H29:M12:M29:Q12:Q20="D1"),--(G12:G29:K12:K291229:T12:T29="FW""G"))/J34
There at the end, the way it goes, the cell is counted only if an "FW" and a
"G" is present. I want it to be an "FW" OR a "G".
Thanks,
Alanb