switch function or sumif?

  • Thread starter Thread starter jaydywan
  • Start date Start date
J

jaydywan

I have the following in a query. TMW is a sum expression. I want to
be able to condense this further using LOC.

LOC EXA TMW
101 BCJ 785.8
11 BCA 6184.8
11 BRL 59.9
113 BCP 2787.2
12 BFY 48.4
15 BFH 6
171 BCY 2216

For instance
101, 11, 11 are at the same place so I want to further sum 785.8,
6184.8, 59.9
113 is on it's own, but 12 and 15 would need to be further condensed
as well...

Can I use a "switch" function, or is there some easier way to do
this...sumif, etc?
 
I would create a table or field that identifies which LOC are the "same
place". You could then group by the "Place" field and sum TMW.
 
Back
Top