Good Afternoon,
In the example below I am able to select the Non Saturn & Saturn Trucks but now I need to see where they fall within certain price points. For example (manually inserted): 2 cars fall below $10,000 ($9999 or less), 1 car falls between $10, 000 and $10,999 and two fall between $14, 000 and $14, 999, and at times some will fall above $15, 000. Is there a way to add something to this:
=SUMPRODUCT(--($A$8:$A$15=A2),--($B$8:$B$15<>""),--ISNA(MATCH($B$8:$B$15,{"Saturn","Saturn Truck"},0))) to find out where they fall?
Thanks in advance,
JJ in SD
In the example below I am able to select the Non Saturn & Saturn Trucks but now I need to see where they fall within certain price points. For example (manually inserted): 2 cars fall below $10,000 ($9999 or less), 1 car falls between $10, 000 and $10,999 and two fall between $14, 000 and $14, 999, and at times some will fall above $15, 000. Is there a way to add something to this:
=SUMPRODUCT(--($A$8:$A$15=A2),--($B$8:$B$15<>""),--ISNA(MATCH($B$8:$B$15,{"Saturn","Saturn Truck"},0))) to find out where they fall?
Thanks in advance,
JJ in SD