Hello,
I've a quite complex (at least for me :-)) problem I should solve
within my excel (possible not using VBA).
Suppose you have this sheet:

week 1/1/06 1/8/06 1/15/06 1/22/06

john 3 5 3 5
---- s s s s
jim 5 5 5 5
---- i i i i
micky 5 5 5 5
----- a a a a
mouse 5 5 5 5
----- w w w w
sara 5 5 5 5
---- s i i i

where, for each week, I've listed the number of days a single resource
(ie micky) and the task (s,i,a,w) he/she will work on (example: john
will be present 3 days on week 1/15 and he will work on task "s")

Now, what I need to do is to summarize how many people/days will be
spend for each task for each week

Something like this:
task *i*
week 8-Jan
people/days == 10



the diffculty is that the "week" and the task for which I need to
summarize the people/days spent, are inputs from user.

I was thinking to use the SUMPRODUCT, but it doesn't work since the
presence of chracters in the interested area ...

Hope the problem is clear enough...
*pimar


--
pimar
------------------------------------------------------------------------
pimar's Profile: http://www.excelforum.com/member.php...fo&userid=5386
View this thread: http://www.excelforum.com/showthread...hreadid=516027