COUNTIF "EVEN" numbers in a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I count how many EVEN numbers in a range?
I tried =COUNTIF(B3:10,"EVEN") but no success.
 
Try this:

=SUMPRODUCT(--(MOD(B3:B10,2)=0))

Note that this will treat blank cells as even numbers. If you want blanks
to be excluded then try:

=SUMPRODUCT(--(MOD(B3:B10,2)=0),--(ISBLANK(B3:B10)=FALSE))

HTH,
Elkar
 
Thanks but it seems complicated....if u take a simple range of numbers like
1, 4, 6, 11, 15, 18.....i should be able to countif 3 EVEN numbers
(4,6,18)...its so simple yet Excel does not allow to define "EVEN" in a
formula?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
COUNTIF Cells in Range? 4
Countif/Vlookup 2
COUNTIF on result of formula 4
Excel Use COUNTIF across a range of cells with formulas 0
Countif formula 2

Back
Top