Posted to microsoft.public.excel.programming

Bob Phillips[_6_] Bob Phillips[_6_] is offline

external usenet poster

Posts: 11,272

sumif weekday

Sorry, missed that bit

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2),B1:B10)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
ups.com...
Hi Bob

Sorry I understand where you include the sum of the numbers in
b1:b10???

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
Sumif weekday	Sungibungi	Excel Worksheet Functions	3	April 7th 10 12:41 PM
WEEKDAY	HK[_3_]	Excel Worksheet Functions	7	February 27th 10 09:15 AM
Weekday and Sumif	Mike	Excel Discussion (Misc queries)	3	December 23rd 07 09:01 AM
WEEKDAY() function: display TEXT not numeric weekday	tom	Excel Discussion (Misc queries)	3	November 21st 06 04:32 PM
Weekday	Darts via OfficeKB.com	Excel Discussion (Misc queries)	3	May 26th 06 06:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us