Hi

I am using a SUMIFs formual to calculate three different types of conditions and referencing them to another sheet.

The formula is: =SUMIFS('All Segments'!D:D,'All Segments'!$N:$N,"Mainspreadsheet!"&B2,'All Segments'!$P:$P,"*"&Mainspreadsheet!C2&"*",'All Segments'!$C:$C,Mainspreadsheet!D2)

Everything works until I add in ",'All Segments'!$N:$N,"Mainspreadsheet!"&B2,'" which is the 3rd condition. Can someone provide a fix for the formula as I am not sure how to fix this particular one. Apologies for the formula not being clean as well, I am an excel newbie.

Thanks