samiam41
asked on
Excel: if cell = x, add
Hey Experts! Got a spreadsheet that contains a list of virtual servers. What I'm trying to do is document which VM's are on which host servers. In the process, I want to show how much memory is committed on each host. Attached is the spreadsheet for reference.
When the word "Host1, host2 or host3" shows up in d15:d23, I want the amount of memory (listed in E15:E23) to be added to the appropriate host under the "Assigned Memory" column (J4:J8).
Thank you for your help!EE_Ref.xls
When the word "Host1, host2 or host3" shows up in d15:d23, I want the amount of memory (listed in E15:E23) to be added to the appropriate host under the "Assigned Memory" column (J4:J8).
Thank you for your help!EE_Ref.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help Samiam!
ASKER
If you get a chance, could you stop by and check this one out please? It builds off this question.
https://www.experts-exchange.com/questions/28948564/Display-DNP-if-value-0-display-Y-if-value-is-greater-than-0.html
https://www.experts-exchange.com/questions/28948564/Display-DNP-if-value-0-display-Y-if-value-is-greater-than-0.html
ASKER