Feb 01 2019 09:55 AM
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!
Feb 01 2019 10:12 AM
It could be
=SUMIF('Itemized Expenses'!C:C,A7,'Itemized Expenses'!B:B)
Feb 01 2019 10:48 PM
Thank you, @Sergei Baklan! Much appreciated. Truly.