I am trying to create a formula on a Sheet 1 to Sum data on Sheet 2. I need to sum column M if the Month in Column C is January. I have tried the following formulas and I am getting an error or 0.
=SUM(IF(MONTH(Sheet2!C2:C25)=1|Sheet2!M2:M25|0))
=SUMPRODUCT(MONTH(Sheet2!C2:C25)=1|Sheet2!M2:M25)
=SUMIF(Sheet2!C:M|MONTH(Sheet2!C:C)=1|Sheet2!M:M)
Bookmarks