Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help with formula
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, |