ExcelBanter - SumIf or SumProduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SumIf or SumProduct (https://www.excelbanter.com/excel-worksheet-functions/130426-sumif-sumproduct.html)

SumIf or SumProduct

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

T. Valko

SumIf or SumProduct

Try this:

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

Biff

wrote in message
ups.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

Ron

SumIf or SumProduct

Try the folowing:

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

" wrote:

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

[email protected]

SumIf or SumProduct

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

ups.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

T. Valko

SumIf or SumProduct

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

ups.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

[email protected]

SumIf or SumProduct

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

[email protected]

SumIf or SumProduct

Thank you!
This also worked.
cheetah

On Feb 12, 5:41 pm, Ron wrote:
Try the folowing:

" wrote:
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

[email protected]

SumIf or SumProduct

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

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

T. Valko

SumIf or SumProduct

Ok, thanks for the feedback!

Biff

wrote in message
oups.com...
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

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

All times are GMT +1. The time now is 05:30 PM.