About Us

Glad to hear you won't have a headache

--
Don Guillett
SalesAid Software

"TKGerdie" wrote in message
...
Thank you very much for the help from both of you. It is much
appreciated.
And much easier on the head instead of banging it on the desk. Have a
great
day.

"Don Guillett" wrote:

See Bob's post and use a cell reference instead of typing in the date.
=sumif(range,a1,range)

--
Don Guillett
SalesAid Software

"TKGerdie" wrote in message
...
The SUMIF works. However, my criteria is =10/24/05 so that I can get
the
sum
of the work done on that day. I want to use this same formula for
every
work
day through the end of the year. Is there an easier way to do this
than
typing the date into the formula every time I carry it into a new
cell?

"Don Guillett" wrote:

Perhaps the SUMIF function will work for you? If not, certainly a
SUMPRODUCT
formula could be devised. Post back if sumif doesn't do it.

--
Don Guillett
SalesAid Software

"TKGerdie" wrote in message
...
I've been reading the discussions trying to find an instance where
someone
has asked about this before and I can't seem to find anything.

The sheet that I have has the date that the work was done and how
many
units
were completed per map section. So there could be multiple rows
with
that
date on it. What I'm trying to figure out is if there is a way to
have
Excel
search for a date and then get all of the units done that day,
even if
they
are on multiple rows. Then I can calculate how many units per day
are
being
done. I don't know how to do VBA, so everything I've been doing
is
using
cell formulas. Does anyone have any suggestions?

Thank you in advance for your help!

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find dates in a range; then sum values in that range by a criteria	Anders	Excel Discussion (Misc queries)	4	October 21st 05 03:41 PM
calculate interest between two dates	Arvind Khanna via OfficeKB.com	Excel Worksheet Functions	1	June 1st 05 01:18 PM
To find a combination of numbers that equal a set amount?	Larry Morris	Excel Discussion (Misc queries)	6	December 17th 04 05:39 PM
calculate with dates before 1-1-1900	jan wan	Excel Worksheet Functions	3	October 29th 04 10:54 PM
How do I ensure dates inputted are during the work week?	Jim Johnson	Excel Worksheet Functions	3	October 29th 04 08:25 AM

Menu

About Us