On Feb 12, 6:16 pm, "T. Valko" wrote:
I just noticed that you're subtracting BU268.

Try this:

=IF(AND(M2680.001,BS268+BT268-BU2680),BS268+BT268-BU268,AZ268*(1-BF268))

Biff

wrote in message

oups.com... On Feb 12, 4:31 pm, "T. Valko" wrote:
Try this:

=IF(AND(M2680.001,SUM(BS268:BU268)0),SUM(BS268:B U268),AZ268*(1-BF268))

Biff

wrote in message

roups.com... 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(M2680.001,(AND(sum(BS268+BT268-BU2680,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

Works perfectly!
Thank you for your time.
cheetah

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