To both FSt1 and Fred Smith.... I would be careful about using
(MONTH(A2:A10)=1) as one of the criteria because if the data spans more than
one year, you will pick up January results for all years listed.

--
Rick (MVP - Excel)



"Fred Smith" wrote in message
...
You need either multiplication, or double unary. You don't need both. So
=SUMPRODUCT((D2:D10)*(C2:C10="yes")*(B2:B10="John" )*(MONTH(A2:A10)=1))
will do.

Fred

"FSt1" wrote in message
...
hi
try this...
=SUMPRODUCT((D2:D10)*--(C2:C10="yes")*--(B2:B10="John")*((MONTH(A2:A10)=1)))

careful. formula wraped .
where D = amount
and C = approved
and B = name
and A = date

adjust ranges to fit your data.

regards
FSt1
"nordiyu" wrote:

Date Name Approved Total
12-Jan-10 John Yes $120.00
15-Jan-10 Mike Yes $50.00
20-Jan-10 John No $300.00
31-Jan-10 John Yes $80.00
02-Feb-10 Mike Yes $50.00
05-Feb-10 John Yes $180.00


Sir,
Needs yr help to formulated how to find out the approved name with
highest
(total $) for the month jan 2010. (expected result for above condition :
Jan
2010 - John - $200.00)