On Sat, 16 Jul 2005 19:58:34 -0500, davmason
wrote:
I am trying to count data entries under two conditions - ie. if it is
red and small count it, .
p.s. I am extracting data from the sheet "data" to a smaller "results"
sheet.
I have tried this formula and can't see why it doesn't work!!??.
=IF(AND(DATA!F2:F46=\"RED\",DATA!E2:E46=\"SMALL\" ),COUNTA(DATA!E2:E46),\"
\")
{=SUM(IF(data!F2:F46="RED",IF(data!E2:E46="SMALL,1 ,0),0)}\
This is an array. Type it without the curly brackets and enter it
using Ctrl-Shift-Enter
MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner
|