How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1997
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I need help with an excel formula. It involved 2 different

This answer was rated:

I need help with an excel formula. It involved 2 different sheets. I want the formula to state:

If cell A23 = "JG," then search for all the "JGs" in column B of a different sheet, the add up all the numbers affiliated with "JG" in column D of that different sheet.

This is the formula I've been playing with, but it doesn't seem to work: =IF(A23="JG",SUM(LOOKUP(A23,CurrentStatus!$B$3:CurrentStatus!$B$2000,CurrentStatus!$D$3:CurrentStatus!$D$2000)))

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

try

The-PC-Guy :

=IF(A23="JG",SUMIF(CurrentStatus!$B$3:$B$2000,"JG",CurrentStatus!$D$3:$D$2000))

The-PC-Guy :

please let me know if you need anything else

The-PC-Guy :

this formula should do it for you

The-PC-Guy :

=IF(A23="JG",SUMIF(CurrentStatus!$B$3:$B$2000,"JG",CurrentStatus!$D$3:$D$2000))

Customer:

ok hang on.... let me try....

The-PC-Guy :

when ready

The-PC-Guy :

PLEASE REMEMBER TO RATE MY SERVICE

The-PC-Guy :

i am here incanse you have any problems with it

Customer:

Perfect....!! Thanks buddy, I appreciate it.

Customer:

JG.

The-PC-Guy and 3 other Microsoft Office Specialists are ready to help you