Thread
:
Omitting Negative Numbers
View Single Post
#
1
Posted to microsoft.public.excel.misc
Caplin Girl
external usenet poster
Posts: 1
Omitting Negative Numbers
Hi there,
I'm wondering if there is a formula that will omit a number from a table
when it is negative. If so, please inform me how to add it to a formula that
looks like this:
=SUM(B90,B109,B149,B168)-B128-B187
Thanks.
Reply With Quote
Caplin Girl
View Public Profile
Find all posts by Caplin Girl