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