Counting, 2 criteria
No just numerical values
"Bob Phillips" wrote:
Does any of Q3:Q3000 have text values?
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"GD" wrote in message
...
Thanks Ron, i've amended it to be relevant to my sheets..
=SUMPRODUCT((MONTH('2008 Errors'!A3:A3000)=1)*('2008
Errors'!P3:P3000="KT")*'2008 Errors'!Q3:Q3000)
as it's referring to another sheets cells, and unfortunately it's
returning
a result of #VALUE!
Any ideas?
"Ron Rosenfeld" wrote:
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
|