SUMIF? or SUMPRODUCT???? or Something else??

**bhodo** · 12-04-2009, 09:32 AM

Can anybody help me with this please:

I want to be able to calculate the total sum of column 'X' if column 'M' says 'Bound' and if column 'O' has a value greater than 0.

I have tried I few things including the below, however i cannot get it to work. If somebody could help me asap that would be much appreciated!

=SUMPRODUCT((M11:M25="Bound")+(O11:O25<0))*(X11:X25)

Thanks

**martindwilson** · 12-04-2009, 09:36 AM

sumproduct(--(m1:m100="bound"),--(O1:O100>0),(X1:X100))

**DonkeyOte** · 12-04-2009, 09:37 AM

To clarify - in SUMPRODUCT (and Arrays) + equates to OR as * equates to AND.

For more info. on Sumproduct see the link in my sig. to Bob Phillips' white paper.

**bhodo** · 12-04-2009, 09:48 AM

Thanks guys!!

This seems to be working now. This is my first post on the forum and something that I have been trying to do for hours has been resolved in minutes!

Thanks again