You seem not to have sent the part of the message where you told us what
formula was giving you trouble, what the data values are, what result you
got, and what result you expected.
--
David Biddulph

"Pedro Dias Ferreira" wrote in message
...
Hi,

I have been battling a problem for the last couple of days and can't
seem to be able to solve it.

I have a column with data regarding a call centre. In one of the
columns I have the date of a phone call and in another one I have the
call outcome. I want to group this by week now, defining ranges of
dates and the outcome for the calls that were made then.

Have tried several different ways with sumproduct but the problem
seems to be in Excel 2003 having some problem with the dates. By the
way, I have the dates that define the ranges in seprate cells and
refer to those cells when defining ranges.

Any help would be more than appreciated

thanks

Pedro