Formulas and Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-3060852%22%20slang%3D%22en-US%22%3EFormulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3060852%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20excel%20for%20my%20customer%20accounts.%20I'm%20needing%20to%20find%20out%20a%20sum%20total%20of%20all%20the%20accounts%20without%20having%20to%20add%20them%20all%20up%20individually.%20Can%20anyone%20suggest%20a%20formula%20or%20a%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Ally%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3060852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

4 Replies

@AMcDonald87 

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

 

Maybe with this formula as shown in the attached file.

@Quadruple_Pawn 

 

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 Screenshot 2022-01-13 at 17.49.17.png

@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?

 

 

Or, @AMcDonald87 , building on what @Quadruple_Pawn 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.