Posted to microsoft.public.excel.programming

[email protected] nicolas.schimpf@gmail.com is offline

external usenet poster

Posts: 2

sumif weekday

HI everyone

I am trying to sum numbers of a specific day of the week like:

sumif(a1:a10;"Monday";b1:b10)

a1:a10 contains date jj/mm/yy like 01/01/2006
b1:b10 contains numbers

I did tried to convert the range a1:a10 into weekdays but this did not
work:

sumif(text(a1:a10;"dddd");"monday";b1:b10)

Can you help me with this formula

Many thanks for your help

Nicolas

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 10:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us