hi all,
how do sum data with condition this below :
sample data with 5 rows :
3
4
2
(blank cell)
9 (sum of result)
after formula : be 4 rows (without blank cell display)
3
4
2
9 (sum of result)
how do to make it without delete / hide blank cell....
thanks in advance
john m
You've got options:
To hide blank rows you can just add a filter to the top of the row with Data -> Filter, then in the filter button unselect blanks.
To delete the blank rows, you can select the whole range, hit F5, choose Special... and in there check the box for Blanks and hit okay. Now go up to Cells -> Delete -> Delete Rows.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
John.
A small sample workbook would be useful. In the meantime did you tried with subtotal?
Something like this..
Formula:
Please Login or Register to view this content.
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.
thanks for your suggestion, my goal is not use Filter or delete/hide>..
any other ideas?
You are welcome but just for knowing it, SUBTOTAL does not needs to work only with filters....
I apologize, I misread your initial post.
Fotis' suggestion is good stuff. Another possible solution is =SUMIF(range,">"&0), if the "blank" cell is actually a formula that results in a blank.
thanks Fotis..It's good for me...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks