Unfortunately, I don't think that will help me. That's the problem I'm complaining about. Your solution, like the others I've seen, is trying to calculate the sum when there are multiple alternatives to the same criteria. I'm trying to sum when there are singular responses to alternative criteria.

Confused?

One example I saw was using formulas to SUMIF when calculating when "Sales Area" = "West" OR "North".

What I'm wanting to do is calculate the results when "Sales Area" = "West" OR "Salesman" = "Bob". All the solutions I've seen so far would unfortunately double-count the results when both criteria were met (i.e. Bob made a sale and it was in the West area).

The workaround I've been using is to add an extra column(let's call it column Q) in the data-set that says something to the effect of =IF(OR("Sales Area" ="West", "Salesmen" = "Bob"), "West Equivalent", "Not West Equivalent"), and then doing a SUMIF on column Q where the criteria for the formula is "West Equivalent".

Another example is say I was searching for a house and deal-breakers were anything over $300,000 or anything less than 4 bedrooms. (Maybe I would then calculate "acceptable" results by using Total Homes - "Deal-Breakers"). I would want a formula that would only sum or count the values for either condition, not count houses that were over $300k and had less than 4 bedrooms twice.

Does that make sense?