SumIF from another sheet
I have a formula that sums up the expenses for a particular billing code, like this:
=SUMIF([Account Code]:[Account Code], "539023", [Expenses Submitted]:[Expenses Submitted])
This works well, however, I want to use this code on a different sheet, without having to link to a bunch of cells on the first sheet. I can't seem to get the sheet references to work (I don't want to put in a range, I want it to sum everything with that account code, as lines are added to the sheet from a form).