Excel Formula for Budget Worksheet

Copper Contributor

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! 

2 Replies

It could be

=SUMIF('Itemized Expenses'!C:C,A7,'Itemized Expenses'!B:B)

 

Thank you, @Sergei Baklan! Much appreciated. Truly.