Forum Discussion
ellagrey
Feb 01, 2019Copper Contributor
Excel Formula for Budget Worksheet
Hi! I'm in need of a formula for the following (see attached file):
On the "Itemized Expenses" tab - for all line items categorized as "Groceries" in Column C, the sum total of all "Groceries" is displayed on the "Budget" tab in cell 7B.
Thanks so much for sharing your expertise!
It could be
=SUMIF('Itemized Expenses'!C:C,A7,'Itemized Expenses'!B:B)
- ellagreyCopper Contributor
Thank you, SergeiBaklan! Much appreciated. Truly.