My fault (untested code)
=SUMPRODUCT((A1:A999="CAR")*(B1:B99910)*(B1:B999< 40))

Sorry,
--
AP

"duane" a écrit dans le message de news:
...
with sumproduct you must specify row range, such as a1:a100 instead of
just a
column such as a:a. empty rows do not hurt (other than speed) so specifiy
a
range thatis ample.

"Tufail" wrote:

sorry to say this error is coming out, pls help me pleaseeeeeeee
=SUMPRODUCT((A:A="CAR")*(B:B10)*(B:B<40)) this error cameout = #NUM!


"Tufail" wrote:

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