Countif
 

I am trying to create a countif formula that meets the following criteria:

if <=0, 0
if =1<=338, 1
if =339, 4
if =340<=351, 1
if =352, 4
if =353, 1

So far, I can only get a value of 1 to return for all criteria with the
following formula:
=+COUNT(IF(430<=0,0,IF(E430=1<=338,1,IF(E430=340 <=351,1,IF(E430353,1,IF(E430=339,4,IF(E430=352,4, 0)))))))

Countif
 

=if(E430<=0,0,if(E430=339,4,if(E430=352,4,1)))

--
Regards,
Tom Ogilvy


"Jeanette" wrote in message
...
I am trying to create a countif formula that meets the following criteria:

if <=0, 0
if =1<=338, 1
if =339, 4
if =340<=351, 1
if =352, 4
if =353, 1

So far, I can only get a value of 1 to return for all criteria with the
following formula:

=+COUNT(IF(430<=0,0,IF(E430=1<=338,1,IF(E430=340 <=351,1,IF(E430353,1,IF(E
430=339,4,IF(E430=352,4,0)))))))

Countif
 

Hi Jeannette,

I am not sure I totally understand what you are trying to do. Your COUNT
function will count the number of results that your nested IF expression
would return and it is 1 by definition. On the other hand, based on the
criteria described you could create the following formula:

=(OR(E430={339,345}))*3+(E4300)

Regards,
KL


"Jeanette" wrote in message
...
I am trying to create a countif formula that meets the following criteria:

if <=0, 0
if =1<=338, 1
if =339, 4
if =340<=351, 1
if =352, 4
if =353, 1

So far, I can only get a value of 1 to return for all criteria with the
following formula:
=+COUNT(IF(430<=0,0,IF(E430=1<=338,1,IF(E430=340 <=351,1,IF(E430353,1,IF(E430=339,4,IF(E430=352,4, 0)))))))