formula to calculate STDEV from totals

[cjcass]

Hi,
In the picture below I have a formula that calculates the STDEV of the totals of the rows in the table. Is there a formula that would calculate the STDEV for the totals, giving the same result, without the separate SUM formulas that are currently present in Col E?
Many thanks

 

[shg]

=STDEV(MMULT(B4:D11, {1;1;1}))

Confirmed with Ctrl+Shift+Enter instead of just Enter.

 

[cjcass]

That's brilliant thanks, but have just realised something that I didn't think of before (apologies) - there may be occasions where one of the columns (eg. Col D for example) doesn't have any data in it so the STDEV's would be calculated from just Cols B&C, can this be incorporated?
Rgds,

 

[cjcass]

ok, have now found a workaround so please ignore my last request, many thanks for your help

 

[shg]

You're welcome.