Sheet Summary Field for Monthly Revenue Totals
I created the following sheet summary formula in an effort to total forecasted revenue for jobs that are scheduled to run during the month of July:
=SUMIF([Scheduled Start]:[Scheduled Start], MONTH(@cell) = 7, ([Projected Revenue]:[Projected Revenue]))
Unfortunately, the above returns #INVALID DATA TYPE. Can anyone tell me what I'm doing wrong?