SumIf or SumProduct

P

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

T. Valko

Try this:

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

Biff
 
R

Ron

Try the folowing:

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

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...
Click to expand...

Works perfectly!
Thank you for your time.
cheetah
 
T

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
 
P

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
Click to expand...

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
 
P

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

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
Click to expand...
 
Top