Hi,

Hopefully one of you Excel gurus can help with a problem I am having. I wanted to know if it was possible to use the sumproduct formula using If and And statements.

The end goal is to look up an advertiser, site, and fiscal quarter. In the data set I have spend but it is designated as actual or forecasted. I want the formula to be able to look up if the spend is actual for Q1, give me that spend, if not, give me the forecasted spend. For some reason, the formula is not working, no mater what I do. Is it possible that I can not combine a sumproduct formula with an IF and And statement?

This is the formual i was trying to play with: IF(MONTH="Actual 1/1/2012" and "Actual 2/1/2012" and "Actual 3/1/2012", SUMPRODUCT((Client=$A2)*(Advertiser=$A$1)*(Quarter=B$1)*Spend),(MONTH="Forecasted 1/1/2012" and "Forecasted 2/1/2012" and "Forecasted 3/1/2012", SUMPRODUCT((Client=$A2)*(Advertiser=$A$1)*(Quarter=B$1)*Spend)))

Attached is a dummy file: Sumproduct help.xlsx

Any help would be greatly appreciated!