On Mon, 11 Feb 2008 03:36:01 -0800, GD wrote:

Hi, if i'm looking for a formula which will total the cumulative values in
cells Q3:Q3000, but only if the criteria in two other sets of cells are
present, ie A3:3000 has a date in the month of January and P3:P3000 has the
text "KT" in it, how would I go about this?
The values in Q3:3000 are in pounds, so i'd be looking for a cumulative
figure if the preivous two criteria are met in other cells.

Cheers

Perhaps something like (not tested):

=SUMPRODUCT((MONTH(A3:A3000)=1)*(P3:P3000="KT")*Q3 :Q3000)
--ron