Posted to microsoft.public.excel.programming

benjo4u

external usenet poster

Posts: 11

sum if dates conditional

I have a spreadsheet with two columns:
H contains dates and J contains x's.

The dates go from May to December. I have figured out the days that each
month starts and ends. So, I want to sum up all rows with an x and in between
two dates. For this, I have

=SUM(IF(All!J3:J214="x",IF(AND(DATE(YEAR(A48),MONT H(A48),DAY(M49))=All!J3:J214,DATE(YEAR(A48),MONTH (A48),DAY(N49))<=All!J3:J214),"1","0")))

But that just gives 0. Any ideas?

-Benjamin

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
Conditional formatting dates	Cindyt	Excel Discussion (Misc queries)	2	March 5th 10 07:05 PM
using conditional formatting with dates	Josh	Excel Worksheet Functions	1	December 3rd 09 10:07 PM
conditional formating using dates	jorgie	Excel Worksheet Functions	3	August 23rd 06 08:06 AM
conditional formatting using dates	creynolds	Excel Discussion (Misc queries)	1	August 8th 06 12:30 AM
conditional formating: dates	steely	Excel Worksheet Functions	1	October 20th 05 11:20 AM

All times are GMT +1. The time now is 08:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us