Copy and Paste Formulas

B

bobdelrn

I need to copy a lot of formulas Across Columns as well as Down Columns.
For Example this formula for the Month of January(1), The only thing that Ineed to change is the "XYZ123"(Which is the Item Number) and the 1(for theMonth) when I drag my formula down then across. Is there an easy day to dothis: =SUMPRODUCT(--('Items Sent To Shop'!B3:B999="XYZ123"),--(MONTH('Items Sent To Shop'!A3:A999)=1),--(ISNUMBER('Items Sent To Shop'!A3:A999)),'Items Sent To Shop'!D3:D999)
Thanks in advance!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 2
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Quick way to fill formulas? 2
Very strange behaviour of VLOOKUP in Excel 2010 4
Copy & Paste 3
Copy Existing Formula Into New Row 0
Copy formulas to next month 3
Copying Formulas 2

Top