Im trying to Sum by Month
The data that is referenced is on a different worksheet in the same workbook.
The table looks like this:
The data is on a worksheet in same workbook called PC
The date is in column AA of Worksheet PC and the title of the column is "Close Date"
And the data that would populate the monthly sum is in column AC of worksheet PC and the title of the column is "Profit/Loss"
View best response
For such sample
formula in C3 is
drag it the right and down.
You may adjust that to your ranges.