Thread: How to Sum by Date,Month,Year running daily totals?

I need help with a Daily Report Sheet.
I need a Daily, Monthly, Year Sum for Cash(sheet2) & Charge(sheet3)

Sheet2 is Month on Row 2, Day is Column A2-33 (a dollar amount is at the intersections)

Pretend today is Jan 2
Sum Daily = is today cell (what formula to get Sheet1 to print the corresponding cell)
Sum Monthly = sum column of (Jan) (what formula to get Sheet1 to sum the current month)
Sum Year =SUM('Sheet2'!B3:M33) ---I got this one

Thanks,
Wayne

For daily cash, =INDEX('Cash Sales'!B3:M33,DAY(TODAY()),MONTH(TODAY()))
For monthly cash, =SUMPRODUCT(('Cash Sales'!B3:M33)*(MONTH(1&'Cash Sales'!B2:M2)=MONTH(TODAY())))
If you want to add the ability to search multiple dates, replace Today() with a cell reference that has the date in question in it.