SumIf or SumProduct

[pwirth]

I'm hoping someone can help with the following...

I tried checking the SUMIF and SUMPRODUCT archives with no success.
Maybe I am not using the correct function.

Here is my current formula

=SUMIF(M268>0.001,(AND(sum(BS268+BT268-BU268>0,BS268+BT268-
BU268),*AZ268*(1-BF268))))

What I want is if the first 2 conditions are met
M268 > .001 and
BS268+BT268-BU268 > 0
then I want the sum of
BS268+BT268+BU268
if not then I want
AZ268*(1-BF268)

Any help would be greatly appreciated!
cheetah

 

[T. Valko]

Try this:

=IF(AND(M268>0.001,SUM(BS268:BU268)>0),SUM(BS268:BU268),AZ268*(1-BF268))

Biff

 

[Guest]

Try the folowing:

=IF(AND(M268>0.001,(+BS268+BT268-BU268)>0),(+BS268+BT268-BU268),+AZ268*(1-BF268))

 

[pwirth]

Try this:

=IF(AND(M268>0.001,SUM(BS268:BU268)>0),SUM(BS268:BU268),AZ268*(1-BF268))

Biff


I'm hoping someone can help with the following...

Works perfectly!
Thank you for your time.
cheetah

 

[T. Valko]

I just noticed that you're subtracting BU268.

Try this:

=IF(AND(M268>0.001,BS268+BT268-BU268>0),BS268+BT268-BU268,AZ268*(1-BF268))

Biff

 

[pwirth]

I just noticed that you're subtracting BU268.

Try this:

=IF(AND(M268>0.001,BS268+BT268-BU268>0),BS268+BT268-BU268,AZ268*(1-BF268))

Biff

I did notice that yesterday and adjusted the formula.
I was the IF and AND statements that I needed help with most.
Thanks again!
This is a great site with such intelligent individuals. I have even
subscribed to the feed!
cheetah

 

[pwirth]

Thank you!
This also worked.
cheetah

Try the folowing:

 

[pwirth]

I was in the process of sending my thank you when my computer froze so
I'm not sure if the message was sent - so I'm sending again!
I did notice the sum and adjusted the formula.
Thank you again!
cheetah

 

[T. Valko]

Ok, thanks for the feedback!

Biff

I was in the process of sending my thank you when my computer froze so
I'm not sure if the message was sent - so I'm sending again!
I did notice the sum and adjusted the formula.
Thank you again!
cheetah