Excell

M

Muddled

Is it possible to make a sum cell not show a total when the value in one of
its source cells is zero? This is on an excell spreadsheet wher I have a
column for "Optional" items & don't want a total unless there is an amount in
the option cell.
 
J

Jay Freedman

Is it possible to make a sum cell not show a total when the value in one of
its source cells is zero? This is on an excell spreadsheet wher I have a
column for "Optional" items & don't want a total unless there is an amount in
the option cell.
Click to expand...

Umm... Try asking in an Excel newsgroup? This one is about Word.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Consolidation Table from Different Excel Tabs with Different Format 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Autonumber field in Excel that behaves the same as Access 0
Word macro that can call cells out of Excel for a find and replace 0
Need Help with a VBA subroutine 0
Excel - Wich Function should I use? 1

Top