COUNT IF

Roses8

Active Member
Joined
Aug 4, 2005
Messages
348
Hi,

In a count if formula, I am trying to get a formula which does the following:

Count if in column D is =>0 and =<3

=COUNTIF(D:D,"=>0 AND =<3")

Thanks. :)
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Try

=Sumproduct(--(D2:D1000>=0),--(D2:D1000<=3))

adjust ranges to suit
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,337
Office Version
  1. 365
Platform
  1. Windows
.. or this perhaps?
=COUNTIF(D:D,">=0")-COUNTIF(D:D,">3")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,543
Messages
5,529,456
Members
409,878
Latest member
DDhol
Top