I'm trying to use SUMIF to collect data from all months in a specific year into one total. It keeps coming up as a zero.
=SUMIF('Monthly Summary'!F6:AU6,"18*",'Monthly Summary'!F10:AT10)
Is the formula I have entered where row 6 is the date (1801, 1802, format, etc,) and row 10 is the revenue I want to add together.
Solved by B. J. in 12 mins