Formula for Quarterly Revenue


I have been attempting to calculate the projected revenue for the quarters. I am at a loss. Just need to find the revenue for each quarter. I provided some of the information that I am looking at.

The formula I used is returning a 0; I fee like I'm close but just can't seem to get it.

=SUMIF([Weighted Forecast]19:[Weighted Forecast]25, "2020 - Q1", [Expected Revenue Quarter]19:[Expected Revenue Quarter]25)

Best Answer