Forum Discussion
I need formula help!
This is wrecking my brain. I need serious help. I have a table of data, below, and I need a formula in the box on the right, to add the totals per department when the date in K1 is the same as the ...
TimLingo
Microsoft
MicrosoftI changed your data into a table which is why the formula is not saying the columns. You can change "Table1[Fuel Net Cost]" to E2:E103, etc. You may also want to put the $ around it as you copy the formula down.
=SUMIFS(Table1[Fuel Net Cost],Table1[Department],$K$5:$K$15,Table1[Invoice date],$K$3)
Thank you