I am preparing a worksheet where I want to take a,
Reference of specific text from Cell A1, if cell A1 contain a text "yes"
then look on Cell A2,
if A2 has text "February" then plus 1 in the value of Cell A3 and show in Cell A4.
if Cell A1 is "No" but Cell A2 is "February" then keep the Cell A4 blank
but
if Cell A2 contain any other value except "February" formula should plus 1 always in Cell A3 value and show in Cell A4.
I am not expert in excel, consider me a binger and advise please.
An expert guidance can solve my problem as well as can be help me to learn.
your guidance will be highly appreciated...