functions

[Guest]

In column A are dates
In column B are values (1, 2, 3)
I want to look at A for a date greater than a specific date then match to B
for a specific number and count as 1 if they match

if A > 11/30/04 and B = 1 then count as 1
If I have 5 rows that fit the criteria then the answer would be 5.

Please help with the formula, I have tried countif and nested in countif.

Thanks
Dawn

 

[peter]

Hi,
Try this...
a b
1 1/1/2005 1
2 1/3/2005 2
3 1/6/2005 3

4 1/7/05 {=SUM(IF(a4>aD1:a3,b1:b3))} this will
return a 6

make sure to use the cntl shift enter combination after
writing the formula.

peter

 

[RagDyeR]

Just *include* the other argument into the formula:
=SUMPRODUCT(--(A2:A999>AF2),--(A2:A999<AF3),--(B2:B999=AG2))

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Ok, one more question. Take the same formula and instead of >AF3 (which is
a
date) I need between AF2 and AF3. (>AF2 & <AF3

Thanks
Dawn

 

[Guest]

Thanks for the help, I figured it out 3 minutes before your response.

 

[CLR]

That's one of the beauties of this system..........."explaining your problem
so others can understand it enough to help you, often shows you the way to
get the answer yourself........"

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

Thanks for the feed-back.