I have a column that I need to sum if multiple columns meet a certain criteria.
The three columns are: Region,
Period, & Restaurant. The column that I want to sum is Units of Hamburgers.
Basically I need to sum the units of
Hamburgers sold in a spreadsheet. The trick is though that some of my line items might repeat. For example, in my
spreadsheet I might have data that looks something like this:
Col A | Col B | Col C | Col D
1 USA | 2008Q3 | McDonald's | 25
2 USA | 2008Q3 | Wendy's | 14
3 USA | 2008Q3 | Burger King | 14
4 USA | 2008Q3 | McDonald's | 14
5 USA | 2008Q3 | Wendy's | 29
I could create a separate column where I create a key: =A1&B1&C1
create my sumif like this: "=sumif(D:D, "USA2008Q3McDonald's",C:C)
I don't really want to create the additional
column D though with the key formula. Is there a way I can do the sumif without adding a key. I thought perhaps of using an
array formula or something, but I've never done this before.
Thanks in advance.