0

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)
G-Man Says 'Reinstate Monica'
  • 8,029
Nanda Prabhu
  • 3

1 Answers1

0

If you want to count rows where all 3 conditions are satisfied - 1) the date matches, column F = "testing" and column C = "Bangalore" try COUNTIFS function

=COUNTIFS('Master Tracker'!E:E,Sheet1!H1,'Master Tracker'!F:F,"Testing",'Master Tracker'!C:C,"Bangalore")

barry houdini
  • 11,212