Thread
:
Cells formatted as currency, need to sum just positives...
View Single Post
#
3
Posted to microsoft.public.excel.misc
Bondi
external usenet poster
Posts: 94
Cells formatted as currency, need to sum just positives...
wrote:
Hi, hope someone can help..
I have columns on monetary values arrived at by:
Row A Quantity (fed from another sheet)
Row B Equals row A
Row C Equals Row B multiplied by a unit cost in another cell.
This spreadsheet is used for inventory tracking, and I need to sum up
the totals (Row B) only if they are positive numbers, negative numbers
need to be treated as zeros. Rows A,B and C are duplicated down my
spreadsheet for different items (engines actually) and need to totalled
only if positive.
I hope this makes sense, can I explain any easier if not?
Thanks in advance.
Mark
(email:
)
Hi Mark,
One way would be to use SumProduct()
Something along the lines of:
=SUMPRODUCT(--(B1:B100),--(B1:B10))
Regards,
Bondi
Reply With Quote
Bondi
View Public Profile
Find all posts by Bondi