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!

## Bookmarks