Hi RMF,

The If function returns a "text" value (i.e. True or False) and the plus
sign in your formula is asking Excel to "sum" a "text" value, therefore it
does not recognize it. From looking at your formula it looks like you want a
value of 1 to return in the cell if it meets the criteria and a value of 0 if
it doesn't. Assuming you will then sum the column to get the total number of
cells that meet the criteria. A very simple solution would be to do separate
If functions in two separate columns, one for .03 and the other <.7
returning a value of 1 then summing the two columns.

Dont really consider myself an expert but HTH

AndreaSykes

"RMF" wrote:

Would like your help for this one:

I have a large sheet with data sorted in columns split for 2004 and 2005
(see below). I want to count the numbers of cells for e.g. 2004 that are
below 3% or above 70% (answers should be 1), however the formula does not
work and I have no idea why.

Appreciate if a expert could have a look at this. hope I explained it good
enough

Thnks in advance, RMF

A B C D E F
1 2004 2005 2004 2005 2004 2005
2 40.00% 80.0% 90.0% 40.0% 50% 60%

=SUM(IF(((A2,C2,E2)<0.03)+((A2,C2,E2)0.7),1,0))

= #VALUE!