sum: sum only profit/loss (office xp)

Topic

New Reply

hello, i need to choose to sum figures that are >0 and <0 over a range more than thousand of cells. can someone help me here? attached is a sample task.

thanks a lot.

Reply | Quote

Replies

In your example workbook:

=SUMIF(A2:A16,">0")

=SUMIF(A2:A16,"<0")

Reply | Quote

=SUMIF(A2:A1000,”>0″)

=SUMIF(A2:A1000,”<0")

Change ranges as appropriate

Steve

Reply | Quote

Coleman and Steve and Kieran,
Thanks. Thanks a lot.

Reply | Quote

Hi,

Set B2 to =SUMIF(A2:A16,”>0″,A2:A16)
Set C2 to =SUMIF(A2:A16,”<0",A2:A16)

For your example.

Adjust the A2:A16 refernces as appropriate for your real list size.

Reply | Quote