Is there any way to use two cell for sumproduct?
= SUMPRODUCT(--(A2:A100=A2),C2:C100) this is the formula I am using, what I
am trying to do is add another cell with A2. Need to have column A and B to
do the sumproduct. Column A is for states, column B is for type of fuel and
column C for gallons. If A is TX and B is red dye fuel, C is 80 gal. If A is
TX and B is diesle and C is 200 gal. If A is OK and B is diesel and C 150
gal. Have total on bottom and trying to keep states and type fuel seperate in
total cell. Any help on this?