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

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

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

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