zach f

Posts: n/a

how do i use the sum if formula with a date range?

Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I make a formula NOT change when the data range is moved?	Alida Andrews	Excel Discussion (Misc queries)	2	January 6th 05 09:02 PM
Date Formula	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 17th 04 07:25 PM
Date formula	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 16th 04 12:41 AM
How do I add a date formula to a cell but hide the contents with .	Emzy Wemzy	Excel Discussion (Misc queries)	2	December 12th 04 01:48 PM
Formula for date function	Markitos	Excel Worksheet Functions	15	November 10th 04 02:05 AM

All times are GMT +1. The time now is 08:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us