Excel 2007 : Checking if number is positive

[superkid]

Hi,

I am trying to sum up all the positive numbers of the search

each column has a identifier and it should add up positive weight of the identifiers in the same group.

example.
cell 1 +3,boy
cell 2 -2, boy
cell 3 +1, boy
cell 4 +3, girl

if the identifier is boy
then it should add up only the positive values of boy which is 3 and 1 = 4

but my function includes the -2 into the summation.

any help will be appreciated

thanks

Please Login or Register  to view this content.

[DonkeyOte]

Perhaps

Please Login or Register  to view this content.

If the positive numbers are not preceded by the + operator you could repeat the 0+ test and just ensure it's greater than 0 .. however if you do have the + / - operator the above requires less coercion.

[DonkeyOte]

Revised formula based on my interpretation of yours such that:

Please Login or Register  to view this content.