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.