Reference another cell on the same row while using SUMIF()
I have a list of Virtual machines with the following fields (VM Name ,Power State ,RAM ,USED STORAGE )
Column B (Power State) can only have two values [PoweredOn/PoweredOff].
I need to sum all the RAM Values and all the Used Storage Values, once for powered on machines and once for powered off.
I tried using sumif, but I don't know how to reference another cell on the same ROW If that makes any sense.... in essence I need the sumif to look at the value of a cell on the same ROW but on another Column as the cell it's trying to evaluate.
I know there's probably a much easier way to achieve this using VBA, but I'd really like to do it using SUMIF.
Column B (Power State) can only have two values [PoweredOn/PoweredOff].
I need to sum all the RAM Values and all the Used Storage Values, once for powered on machines and once for powered off.
I tried using sumif, but I don't know how to reference another cell on the same ROW If that makes any sense.... in essence I need the sumif to look at the value of a cell on the same ROW but on another Column as the cell it's trying to evaluate.
I know there's probably a much easier way to achieve this using VBA, but I'd really like to do it using SUMIF.
Could you send a sample?
ASKER
Indeed, Please see attached.
example.xlsx
example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Plain and simple.
Great solution (Kind feel stupid for not solving it myself though)
Thanks a lot!
Great solution (Kind feel stupid for not solving it myself though)
Thanks a lot!