Data counting from different sheets

July 11, 2011 at 23:33:46
Specs: Windows 7, AMD Athlon 3500+ / 528 Mb
Hello!

I want to count every time whet a cell calue is equal to 0 , different than 0 and cell value varies between -5 and + 5 ; every time when one of this conditions is met the formula will wount 1 and place it in corespondend column. The counting will be done for pairs of 5 cells. (please see atachement)

An example of what I want to do is attached !!

http://www.sendspace.com/file/kh7sb4


See More: Data counting from different sheets

Report •

#1
July 12, 2011 at 12:24:09
Your looking for =COUNTIF() and =COUNTIFS() functions:

Try this:

I want to count every time whet a cell calue is equal to 0

=COUNTIF(A2:A26,0)

different than 0

=COUNTIF(A2:A26,"<>0")

cell value varies between -5 and + 5

=COUNTIFS(A2:A26,">-5",A2:A26,"<=5")

You will need Excel 2007 for the =COUNTIFS() function.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question