Hi
=SUMPRODUCT(--(A1:A10="Sam"),--(B1:B10="Jan"))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

"Darin Kramer" wrote:



Hi Guys!

Question is :
Two columns of data
Column A is names (say a1:a10) and includes names Pete and Sam
Column B is date (say jan, feb, march)

I want to COUNT for all entries of Name 1, AND for a date requirement in
Column B. Think its a nested countif....

So in above Example - Sams name may appear four times in column A, and
next to first instance says Jan, second says March, third says Jan and
fourth says Jan... I want a formulae that counts the 4 appearences of
JAN for Sam.... help.... :)

Regareds

D


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!