Formulas and Functions

[AMcDonald87]

Hi all

I use excel for my customer accounts. I'm needing to find out a sum total of all the accounts without having to add them all up individually. Can anyone suggest a formula or a way to do this?

Thanks, Ally

[#2]

@AMcDonald87 

=SUMPRODUCT((F4=$C$4:$C$24)*$D$4:$D$24)

Maybe with this formula as shown in the attached file.

[#3]

@OliverScheurich 

I need to able to add the totals on every person named at the bottom of the page from A-Z. I have attached a screenshot to show you what I mean

Thanks 

[#4]

@AMcDonald87 

In cell A1 of the attached file you can select the customer from the dropdown in order to sum up the total. Is this what you want to do?

[#5]

Or, @AMcDonald87 , building on what @OliverScheurich created, using the INDIRECT function, is this what you're looking for. The total of all those subordinate sheets. INDIRECT is the way to do that.