Posted to microsoft.public.excel.worksheet.functions

LQQKB4uleep LQQKB4uleep is offline

external usenet poster

Posts: 2

need help writing function

Column A has Days of the week listed for the entire month
Column B has data listed for days of the week
Want formula to count data in column B if it equals a certain day of the week

like if sunday then count all data listed for sundays in column B

"a" "B"
Sunday 21
Monday 15
Tuesday 28

Sunday 14
Monday 10
Tuesday 12

sunday=35
Monday=25
Tuesday=40

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
Need Help With Writing Concatenate Function	Michael Styles[_2_]	Excel Worksheet Functions	5	August 15th 09 05:20 PM
Function writing help	Gator	Excel Worksheet Functions	2	March 2nd 09 05:51 PM
WRITING A WHAT IF FUNCTION	MARY	Excel Worksheet Functions	1	June 13th 08 12:36 PM
Why doesn't writing a nested IF function work?	Littlerose210	Excel Discussion (Misc queries)	1	April 8th 08 06:01 AM
Help Writing Function	JamesEXCELhelp	Excel Worksheet Functions	8	January 4th 08 06:06 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us