Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i add in numbers automatically based on adjacent cells cont | Excel Discussion (Misc queries) | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
Count cells with strikethrough font? | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Count cells with data | New Users to Excel |