Menu

calculate count on 2006 total, 2005 total, etc...

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

calculate count on 2006 total, 2005 total, etc...

simple

--
Don Guillett
SalesAid Software

"Tieske" wrote in message
...
sounds pretty complicated, why not use a simple pivot table?

Tieske

"Amanda Deshotel" wrote in
message ...
Here is the jist of what my spreadsheet looks like:
Column D contains injury dates in mm/dd/yy format. At the bottom of my
spreadsheet, I am breaking out the years for a total count of injuries
during
that year. So, if there were 8 injuries in column d2:d33, and the year
was
greater than or equal to 01/01/06, I want it to pull "8".

"Biff" wrote:

You need to provide at least *some* detail!!!

Biff

"Amanda Deshotel" <Amanda wrote in
message ...
I am working on a spreadsheet for workers comp injuries. I need to
have a
total of injuries broken out per year. I can't seem to get the
function
to
work properly...probably because I am using the wrong one. Any ideas?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Calculate Total Sales from a Database	John	Excel Worksheet Functions	0	November 3rd 05 12:26 PM
Help with a formula	Diilb	Excel Discussion (Misc queries)	6	August 18th 05 06:11 PM
Date Calculations	Bruce	Excel Worksheet Functions	11	May 19th 05 01:09 AM
excel calendar year resetting 2005 2006	whowatwerwyhow	Excel Discussion (Misc queries)	1	May 16th 05 12:29 PM
Sumif Linking to Another Workbook error #VALUE!	Tunde	Excel Discussion (Misc queries)	16	March 4th 05 03:02 AM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement