J
Joseph
I use this current formula to keep track of cars sold in a month. I want to
keep track of the different models sold at our store in a month and have paid
cash. I keep a log in Worksheet1 and I want to have the results show in
worksheet2. Is there a way of streamlining the date portion to equal the
heading in Worksheet2?
Worksheet1
SUMPRODUCT((WORKSHEET1!$A$3:$A$1737="JANUARY")*(WORKSHEET1!$C$3:$C$1737="MODEL-A")*(WORKSHEET1!$J$3:$J$1737="CASH")*WORKSHEET!$H$3:$H$1737)
Worksheet2
JAN FEB MAR APR MAY JUN JUL AUG SEPT OCT NOV DEC
Model-A
Model-B
Model-C
Any help is greatly appreciated,
Thanks,
keep track of the different models sold at our store in a month and have paid
cash. I keep a log in Worksheet1 and I want to have the results show in
worksheet2. Is there a way of streamlining the date portion to equal the
heading in Worksheet2?
Worksheet1
SUMPRODUCT((WORKSHEET1!$A$3:$A$1737="JANUARY")*(WORKSHEET1!$C$3:$C$1737="MODEL-A")*(WORKSHEET1!$J$3:$J$1737="CASH")*WORKSHEET!$H$3:$H$1737)
Worksheet2
JAN FEB MAR APR MAY JUN JUL AUG SEPT OCT NOV DEC
Model-A
Model-B
Model-C
Any help is greatly appreciated,
Thanks,