Hi All
I am adding an array of cells A4 to A16.
If any of the cells A4 to A16 are either blank or have a zero value I need the answer cell A17 to return a blank.
Thanks
Hi All
I am adding an array of cells A4 to A16.
If any of the cells A4 to A16 are either blank or have a zero value I need the answer cell A17 to return a blank.
Thanks
Hi
Try.
=IF(COUNT(A4:A16)<>13,"",COUNT(A4:A16))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I think this will give you what you need:
=IF(OR(COUNTIF(A4:A16,0)>0,COUNTIF(A4:A16,"")>0),"",SUM(A4:A16))
Sorry Guys stuffed up my explanation.
Should of left out the "any Cells" part
Just need to return a blank cell if A4 to A16 cells are blank or zero but Sum if a value is present
SORRY
deleted... did not read latest update by OP.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Then...
=SUM(IF(COUNTIF(A4:A16,">0"),A4:A16))
Is this, works for you?
Or
=IF(COUNTA(A4:A16)=0,"",SUM(IF(COUNTIF(A4:A16,">0"),A4:A16)))
Thanks Great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks