Hello,
I'm have a spreadsheet with sales info. The price of each product is on row 2. Every row after this is a quantity of product sold by date. In Column AD, I would like the total sales for the day. I made 3 examples in row 2-5. Now I am trying to get Excel to recognize the pattern by highlighting column AD 2 thru 5, and dragging that box to AD6, but it is not recognizing the pattern and multiplying incorrectly.
Do you have any suggestions for this?
Thanks for the help.
Bookmarks