ExcelBanter - If then else

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If then else (https://www.excelbanter.com/excel-discussion-misc-queries/152334-if-then-else.html)

If then else

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

If then else

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

" wrote:

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?

All times are GMT +1. The time now is 04:13 AM.