Automatic YTD Formulas

Hi.

I'm needing assistance with figuring out how to input formulas into my spreadsheet so that the YTD (Year-to-Date) column automatically updates whenever I add information for the next week.

If you look at the spreadsheet, you'll see that I've manually input formulas. However, I need it to be automatic. This is just for one of my stores, I oversee 30 different stores, and definitely won't have the time to keep inputting the YTD information manually.

Any help with this, would be greatly appreciated.

-Phen

In O3

=SUMPRODUCT(($C3:N3)*($C$2:N$2="Qty"))

in P3

=SUMPRODUCT(($C3:O3)*($C$2:O$2="Lbs"))

AWESOME! You've just saved my life!
Question: Do I use the same formula base for cells O24 to O26?

Yes

=SUMPRODUCT(($C24:N24)*($C$2:N$2="Qty"))

and similar for 36 to 41, 57 to 59