Posted to microsoft.public.excel.misc

Mike

external usenet poster

Posts: 3,101

Weekday and Sumif

Hey, I'm wanting to do a sumif formula where the criteria is a certain
weekday. For example:

=SUMIF(A10:A56,WEEKDAY(3),D10:D56)

Which, in theory would return the sum range wherever a tuesday occurs.

It's coming up 0. Anybody know what I could do?

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
WEEKDAY() function: display TEXT not numeric weekday	tom	Excel Discussion (Misc queries)	3	November 21st 06 04:32 PM
WEEKDAY()	Epinn	New Users to Excel	29	September 10th 06 11:39 AM
Weekday	Darts via OfficeKB.com	Excel Discussion (Misc queries)	3	May 26th 06 06:26 PM
Weekday	Thomas	Excel Worksheet Functions	6	January 29th 06 01:07 AM
WEEKDAY using IF	lunker55	Excel Discussion (Misc queries)	2	December 4th 04 03:34 PM

All times are GMT +1. The time now is 05:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us