SP cannot use whole columns, you must specify the range, and all ranges must
be the same size.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Tufail" wrote in message
...
thank you very much for quick reply, but sorry to say problame not solved
yet, following error is comingout.

#NUM! =SUMPRODUCT((A:A="A")*(B:B10)*(B:B<40))
CAR 11
BOOK 15
APPEL 20
CAR 25


"Ardus Petus" wrote:

=SUMPRODUCT((A:A="car")*(B:B10)*(B:B<40))

HTH
--
AP

"Tufail" a écrit dans le message de
news:
...
hi , again please someone tell me about follow formula.
i want to count if c/A has car and c/B has# 10 & <40
--A--- --B--
Car 11
Book 20
Appel 40
Car 30

thanks in advance.
tufail