If then else

nfak · Jul 31, 2007

I wish to do if then else in Excel.
If cell in Column A=Aug 15 and Cell in column B="Yes" then increase counter
by ONE. How do I do this?

Teethless mama · Jul 31, 2007

=SUMPRODUCT(--(TEXT(A1:A100,"mmm dd")="Aug 15"),--(B1:B100="Yes"))