I've tried looking at a bunch of forum posts but to no avail...
This is how the formula exists now:
=SUMIFS(Payback_Amount,Payback_Account,$A$21,Payback_Period,I$8,Payback_Fiscal_Year,I$7,Payback_Project,$B$4,Payback_Name,"*BLANK*")
But I want ADD another column in the sum range so that it functions like this:
=SUMIFS(Payback_Amount+HSV,Payback_Account,$A$21,Payback_Period,I$8,Payback_Fiscal_Year,I$7,Payback_Project,$B$4,Payback_Name,"*BLANK*")
Excel won't allow me to include two columns in the sum range. In looking at other posts it seems like something that sumproduct might be able to do, but I can't for the life of me figure out how. I DON'T want to do this:
=SUMIFS(Payback_Amount,Payback_Account,$A$21,Payback_Period,I$8,Payback_Fiscal_Year,I$7,Payback_Project,$B$4,Payback_Name,"*BLANK*")+SUMIFS(HSV,Payback_Account,$A$21,Payback_Period,I$8,Payback_Fiscal_Year,I$7,Payback_Project,$B$4,Payback_Name,"*BLANK*")
Any ideas??
Bookmarks