# Looking for an efficient way to sum

1. ## Looking for an efficient way to sum

Book3.xlsx

In the attached file I have two sheets: one with two columns for store numbers and their loss, another with "table" indicating which Area Managers have which stores.

I want to write a formula that will add up the loss for all stores an area manager has. I can think of a couple of ways, but they seem a bit messy:
• sum of Vlookups
• rework the stores and AM list and then do a SumIf

Can anyone suggest a cleaner/more efficient way?

2. ## Re: Looking for an efficient way to sum

Try

in H3 and copy down

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Looking for an efficient way to sum

Try this in H3:

=SUM(SUMIF(Stores!\$A\$3:\$A\$61,C3:G3,Stores!\$B\$3:\$B\$61))

4. ## Re: Looking for an efficient way to sum

Great! Thanks! I wasn't familiar with SUMPRODUCT. I'll have to read up on it. :-)

5. ## Re: Looking for an efficient way to sum

An alternative:
``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1