You can isolate the power supply of the SRAM cell (otherwise you measure the whole consumption if it is connected to other cells) and then you can measure the current absorbed by the SRAM cell.

You must consider the power during hold operation for static power dissipation and write and read power for dynamic power dissipation for a single cell.

In order to do so, you can use the following command during the period of the operations mentioned above.

.meas [avg_power] AVG P([Vsupply]) from=[Tstart] to=[Tfinal]