spirosu Wrote:
---Date-------Individual-----Type of Work---Amount
____________________________________
7/26/2005---John Smith---Related Work---2
7/27/2005---John Smith---Confirm---------4
7/27/2005---John Smith---Related Work---1
7/27/2005---John Smith---Related Work---1

Hi everyone, was hoping someone could help me with the above. My goal
is to sum product the above based on the criteria of "date", and "type
of work".

For instance, I want to look up date 7/27/2005, and add the amount of
"Related Work" done on that day, based on the above, I should have a
sum of 2.

I'm all over the place with this one, if anyone can lend a hand, it'd
be greatly appreciated. Thanks in advance.

SD

Hi SD

Try a pivot table

Paul


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