Adding numbers together that are from same location

[davidingilbert]

Hello all.

I attempting to develop a forumla to account for 50 locations I am responsible for that will add different numbers together based on a specific location.

For example, if the location says "Los Angeles", I need the formula to look for all instances of "Los Angeles", the quantity of items sold and add them up for me in one spot.

Thank you in advance.
Dave

[AlKey]

Hi davidingilbert,

I suggest that you upload a sample spreadsheet with about 10-15 rows of data so we could figure our a solution for you.

To upload a file click on Go Advanced on the bottom of your screen, then click on paperclip icon and Add Files.

[Jonmo1]

Sounds like a job for SUMIF

=SUMIF(A1:A1000,D1,B1:B1000)

A1:A1000 = all locations
B1:B1000 = Quantity
D1 = Location of Interest.

[easyexcelanswers]

Using an array would work in this instance

{=Sum(if(B2:B22="Mon", C2:C22, 0))}

B2:B22 is the location

c2:C22 is the number of sales

Type in the formula without the curly brackets
Prior to pressing enter, press CTRL-Shift- Enter
Curly brackets will be entered around the formula and the values will be treated as an array