Sum and If Assistance Please
 

I am trying to work with excel to make an if statement work.

Here is an example of what I am trying to do.

If the text on worksheet 1 from F1 to F80 = "Accepted" AND
if the range on worksheet 1 from e1 to e80 = worksheet 2 b2; then sum the
range on worksheet 1 from g1 to g80

Is this even possible, or even better is it understandable?

Thanks everyone

Angela

Sum and If Assistance Please
 

Hi,

Both possible and understandable. Put this on sheet 2.

=SUMPRODUCT((F2:F80="Accepted")*(E2:E80=Sheet2!B2) *(G2:G80))

Mike

"angelagrasser71" wrote:


I am trying to work with excel to make an if statement work.

Here is an example of what I am trying to do.

If the text on worksheet 1 from F1 to F80 = "Accepted" AND
if the range on worksheet 1 from e1 to e80 = worksheet 2 b2; then sum the
range on worksheet 1 from g1 to g80

Is this even possible, or even better is it understandable?

Thanks everyone

Angela

Sum and If Assistance Please
 

oops
I meant put it on sheet 1
Mike

"Mike H" wrote:

Hi,

Both possible and understandable. Put this on sheet 2.

=SUMPRODUCT((F2:F80="Accepted")*(E2:E80=Sheet2!B2) *(G2:G80))

Mike

"angelagrasser71" wrote:


I am trying to work with excel to make an if statement work.

Here is an example of what I am trying to do.

If the text on worksheet 1 from F1 to F80 = "Accepted" AND
if the range on worksheet 1 from e1 to e80 = worksheet 2 b2; then sum the
range on worksheet 1 from g1 to g80

Is this even possible, or even better is it understandable?

Thanks everyone

Angela

Sum and If Assistance Please
 

thank you

you saved me :)

"Mike H" wrote:

Hi,

Both possible and understandable. Put this on sheet 2.

=SUMPRODUCT((F2:F80="Accepted")*(E2:E80=Sheet2!B2) *(G2:G80))

Mike

"angelagrasser71" wrote:


I am trying to work with excel to make an if statement work.

Here is an example of what I am trying to do.

If the text on worksheet 1 from F1 to F80 = "Accepted" AND
if the range on worksheet 1 from e1 to e80 = worksheet 2 b2; then sum the
range on worksheet 1 from g1 to g80

Is this even possible, or even better is it understandable?

Thanks everyone

Angela