If And functions

  • Thread starter Thread starter wella
  • Start date Start date
W

wella

I have 5 sheets listing data and a total in a cell in sheet 6 whic
takes the data from the 5 sheets. I want to be able to put a blan
space in the total cell if all the cells which I'm taking data from i
each of the 5 sheets are blank or calculate a sum if there are an
figures in any of the cells in the 5 sheets. How do I do this
 
I have 5 sheets listing data and a total in a cell in sheet 6 which
takes the data from the 5 sheets. I want to be able to put a blank
space in the total cell if all the cells which I'm taking data from in
each of the 5 sheets are blank or calculate a sum if there are any
figures in any of the cells in the 5 sheets. How do I do this?
Click to expand...

One way, depending on how your data is setup:


=IF(COUNT(Sheet5:Sheet1!A2)=0,"",SUM(Sheet5:Sheet1!A2))


--ron
 
Hi wella!

Thanks are always appreciated but keep them to the original thread as it
helps Google searchers to know that a suggestion works as advertised.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top