I want to compare the month value (=TEXT(A1,"MMMMMM")
) from sheet A with a cell value (JULY) in sheet B using an IF
statement.
If the months are same then I need a sumproduct of the cells in sheet A.
This formula is not working:
=IF(Master!E7:E100=Sheet1!H1,(SUMPRODUCT((Master!F7:F100="Testing")*(Master!C7:C100="Bangalore"))),0)
Master
andSheet1
. Be consistent. … (Cont’d)=TEXT(A1, "MMMMMM")
) … with a cell value …” What does this have to do with the rest of the question? Why does your formula not contain=TEXT(…,"MMMMMM")
? Is that buried in theMaster!E7:E100=Sheet1!H1
? If so, is that part of the problem? Is that part working? If the=TEXT(…, "MMMMMM")
is working, I’m not sure it’s relevant to the question. And, if it’s not working, then you need to make it clear, and not hide it. … (Cont’d)