View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tufail Tufail is offline
external usenet poster
 
Posts: 168
Default COUNTIF with two colunms

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