oakwood_001
Board Regular
- Joined
- Apr 4, 2008
- Messages
- 108
Hi All,
I'm trying to exclude several criterion from a list in a SUMPRODUCT formula with little success.
I've tried doing it using a range in the example shown below:
=SUMPRODUCT(--(Data!$A$18:$A$130="Ford"),--(Data!$B$18:$B$130<>S14:S18),--(Data!$C$18:$C$130=B13),--(Data!D$18:D$130))
Where in this example
A:A is a list of car makes
B:B is the model of the car where I want to exclude certain list of values which is in the range S14:S18
C:C is the year of manufacture
D:D is a number range that I want to return
<tbody>
</tbody>
How would I also type this formula by using a manual list of exclusions? e.g. "Focus", "Fiesta", "Mondeo"
Help greatly appreciated.
I'm trying to exclude several criterion from a list in a SUMPRODUCT formula with little success.
I've tried doing it using a range in the example shown below:
=SUMPRODUCT(--(Data!$A$18:$A$130="Ford"),--(Data!$B$18:$B$130<>S14:S18),--(Data!$C$18:$C$130=B13),--(Data!D$18:D$130))
Where in this example
A:A is a list of car makes
B:B is the model of the car where I want to exclude certain list of values which is in the range S14:S18
C:C is the year of manufacture
D:D is a number range that I want to return
Car Make | Model | Year | Volume |
Ford | Focus | 2009 | 4 |
Hyundai | i30 | 2010 | 7 |
Mazda | MX5 | 2011 | 8 |
Ford | Fiesta | 2009 | 10 |
Ford | Mondeo | 2008 | 3 |
<tbody>
</tbody>
How would I also type this formula by using a manual list of exclusions? e.g. "Focus", "Fiesta", "Mondeo"
Help greatly appreciated.