Jan 13 2022 08:58 AM
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
Jan 13 2022 09:29 AM
=SUMPRODUCT((F4=$C$4:$C$24)*$D$4:$D$24)
Maybe with this formula as shown in the attached file.
Jan 13 2022 09:52 AM
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
Jan 17 2022 01:57 PM
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?
Jan 17 2022 03:51 PM
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.