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")*(WO RKSHEET1!$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,