counting in exel chart

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

Guest

I have columns of numbers some are interger number some are numbers with
decimal places. I want to count the number of integer numbers in each column
any ideas which formula I use. I have tried countif but cant find anyway of
specifying the integer number?
 
this is an array formula which must be entered using
ctrl+shift+enter

=COUNT(IF(MOD(H3:H6,1)=0,H3:H6))
 
You must log in or register to reply here.

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

Excell - two conditions count if factors are true when negative nu 2
Excel 2003 Counting multiple number entries in a single cell 6
Finding the weighted average of text that have been given values 1
counting repeats. 8
Excel How to count from a column if specific condition in another column is true 3
need help on either doing a loop and counting specific values orusing subtotal function 2
count based on single number 13
How to count a coloum if two conditions are met 5

Back
Top