View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Formula help - Sum results Pass or Fail

I'm so glad I could help, Nadine.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Nadine" wrote in message
...
YES :-) that did the trick perfectly. Thank you thank you.. Been at
this
for awhile now. I'll be adding this to my list of formula tips.

"Ron Coderre" wrote:

Perhaps this?
=IF(COUNT(J8:R8),IF(SUM(J8:R8)<=8,"Fail","Pass")," no data")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Nadine" wrote in message
...
Tried that originally, but at the bottom of the column want a count for
all
that say Fail
Problem is when copy the formula down the column it sets all to Fail
because
there isn't any data entered yet, so the count value is wrong. As data
will
be entered daily, but there will be blank rows until the entire month
is
filled in. But need the count to reflect current count for any day
that
they look at it. So if the entire column says Fail, the count will be
wrong.

Not too sure how to work around that unless I put in default values in
all
the rows and columns, not wanting to do that as it will throw off the
count
for all the other columns. And not giving true totals.
Is there a way to leave the pass/fail value blank until it has numbers
in
the cells to sum?

"Ron Coderre" wrote:

Try this:

=IF(SUM(J8:R8)<=8,"Fail","Pass")

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Nadine" wrote in message
...
Need help with a formula.

Want to sum the total of a range of cells, then if it is less then a
specific number the value should be "Fail", if greater then that
number
then
value should be "Pass"

I've used the And function True or False results. But they want the
value
in the cells to say either Pass or Fail.

current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8)

Thanks