COUNTIF with more than 1 condition

  • Thread starter Thread starter Kees Wouters
  • Start date Start date
K

Kees Wouters

Hello,
i am looking for an answer on how to use more than 1
criterium. For example:
range is weight in KGS, condition is: weight between 500 -
1000 kgs. In excel i've tried to use:

=SUM(COUNTIF(D3:D232;"1000<>500"))
this does not work. Can someone help me out here ?
Thanks
Kees
 
=COUNTIF(D3:D232,">500")-COUNTIF(D3:D232,">=1000")

depending on if you want to include or exclude you have to change the > etc

you can use SUMPRODUCT as well but no need for that in this case
 
Hi Kees,

Try

=SUMPRODUCT((D3:D232>=500)*(D3:D232<=1000))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top