SOLVED

Help

Copper Contributor

Trying to get totals in the H column to reflect/update as charges are added to the sheet, thank you for your help!

 

*greg*

2 Replies
best response confirmed by excelnoob15 (Copper Contributor)
Solution

@excelnoob15 

Enter the following formula in H3:

=SUMIF(Table1[Type Of Charge],[@Column1],Table1[Amount])

And in H11:

=SUM(Table3[Column2])

Thank you so much! Worked perfectly.
1 best response

Accepted Solutions
best response confirmed by excelnoob15 (Copper Contributor)
Solution

@excelnoob15 

Enter the following formula in H3:

=SUMIF(Table1[Type Of Charge],[@Column1],Table1[Amount])

And in H11:

=SUM(Table3[Column2])

View solution in original post