Cells formatted as currency, need to sum just positives...

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: mambros2@removenumbers123456ford.com)

=SUM(IF(B2:B20>0),B2:B20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<onyerbikemark@yahoo.co.uk> wrote in message
news:1152197329.228726.53130@q16g2000cwq.googlegroups.com...
> 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: mambros2@removenumbers123456ford.com)
>

onyerbikemark@yahoo.co.uk 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: mambros2@removenumbers123456ford.com)

Hi Mark,

One way would be to use SumProduct()

Something along the lines of:

=SUMPRODUCT(--(B1:B10>0),--(B1:B10))

Regards,
Bondi

Try this:

=SUMIF(B1:B100,">0")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

<onyerbikemark@yahoo.co.uk> wrote in message
news:1152197329.228726.53130@q16g2000cwq.googlegroups.com...
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: mambros2@removenumbers123456ford.com)

Thank you for the replies, I have used SUMPRODUCT and it satisfies my
needs 100%.

Thank you for taking the time to reply.

Regards,

Mark
Ford Motor Co.