Posted to microsoft.public.excel.misc

grizzly6969 grizzly6969 is offline

external usenet poster

Posts: 79

sumproduct tracking

I have a spred sheet tracking absenteeism using the following formula
=sumproduct(--('sheet1'!B1:B100="John Doe"),--('sheet1'!C1:C100="sick"))
each time John Doe is sick it displays on sheet 2
in column A is the dates - ------ I wish to track it Quarterly --- is it
possible to add a third criteria so it will track from (Jan. 01/09 to March
31/09) (April 01/09 to June 30/09 ) etc. I would prefer to use dates if
possible

--
grizz

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
sumproduct function, Bob P please see tracking sheet help	Dale G[_2_]	New Users to Excel	9	July 30th 08 05:08 PM
Tracking GPA	[email protected]	Excel Discussion (Misc queries)	6	April 15th 08 06:34 PM
Tracking Changes	Mimi	Excel Worksheet Functions	6	December 15th 06 06:04 PM
How to insert tracking numbers into my webpage for RMA tracking	wiglady	Excel Discussion (Misc queries)	0	April 4th 06 12:44 PM
tracking changes	Hillie	Excel Worksheet Functions	2	December 28th 04 02:22 PM

All times are GMT +1. The time now is 03:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us