#1
|
|||
|
|||
SUMIF with Or
Googling around, it looks like popular solutions with using multiple possible criteria for SUMIF involve using SUMPRODUCT or adding multiple SUMIF functions, but this won't work for what I'm needing.
Without getting into messy details, I'm trying to use a formula that determines if something is "Off Spec". There are multiple categories why something is off spec, and a given record could be off spec for more than one reason. So, trying to use the solutions above would simply count one record twice. One solution to the issue is having an extra (hidden) column after each entry that does something like =IF(OR(D1 ="Corrosive", E1 >70), "Off", "On"), and then doing a SUMIF off this hidden column. However, I was wondering if there was a way to do the same search from the SUMIF area instead of having to add an extra column of information. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sumif with Conditions | Haha88 | Excel | 2 | 12-21-2016 12:08 AM |
Another SUMIF | OTPM | Excel | 6 | 06-06-2016 03:00 AM |
VBA sumif | Nisio07 | Excel Programming | 0 | 02-26-2016 07:53 AM |
Need help sumif with variable for VBA | jingo | Excel Programming | 4 | 01-23-2014 11:02 AM |
Average if and sumif | jennamae | Excel | 4 | 01-17-2014 05:10 AM |