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
|