Sum ifs with multiple sum criteria

[Vic.J]

Hi,

My objective is to use a sumifs formula (if possible) to calculate the sum of an item with multiple criteria and multiple sum ranges, but I don't think this is possible. I have googled it and many forums said use sumproduct, but the descriptions and the way it was done was confusing. What is the best way to get the result I am after

Thank you

[6StringJazzer]

This looks like a simple VLOOKUP problem so maybe your data is more complex that it looks. Do equipment pieces appear more than once in Worksheet 1?

[Vic.J]

Can you please provide the solution to having the equipment come up just once using a vlookup (note I have not done a vlookup with multiple criteria in the past). In addition can you please provide the solution to pieces of equipment coming up more than once. The reason I ask for both is because I don't exactly know what the exact requirement will be from my boss at work

Thank you

[6StringJazzer]

Here's a SUMIF solution but I still think what's in your head may be more complex than your example, because this is so straightforward. Each sum figure is based on a specific column of data so I don't see why you would need to use multiple criteria.

[Vic.J]

The issue is that on the spreadsheet I am working with has a data validation list in Cell I5. So i have an option of picking "Daily or Monthly.

[6StringJazzer]

That helps. It's always important to explain the whole problem.

This solution is somewhat more general that absolutely necessary. It could be done a little more simply with an IF to test for Monthly or Daily. But in this case I made it more general so it can be easily adapted to use more columns, different header labels, etc. It calculates a sum, in case a piece of equipment appears more than once.