TKGerdie Wrote:
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!

Hi TKGerdie

Really need a bit more info about your data to give a truly informed
response, but you could look at using a Pivot Table or the SUMIF
function


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480846