Count

  • Thread starter Thread starter Flipside
  • Start date Start date
F

Flipside

Hi,

Need some help on COUNT.

Need to count all values which are between 0 & 2 (this is on another
sheet within my spreadsheet called "Data")


Any help would be sweet.

Thanks
 
=COUNTIF(Data!A1:A100>=0)-COUNTIF(Data!A1:A100>2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thanks for your reply but it says that there are too few arguements....
Any ideas?
 
Sorry, wrong syntax

=COUNTIF(Data!A1:A100,">=0")-COUNTIF(Data!A1:A100,">2")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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

SUMIFS ONLY UNTIL the number REPEATS 1
Excel Formula - Count Dates from another Sheet 8
Count in a range of numbers 8
About references 1
COUNTIF + ADDRESS Issue 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Count the columns from one sheet and paste it in another sheet 0
Excel Date Count 2

Back
Top