Display Totals In MsgBox
 

I have a list of Categories in A7:A23 e.g

Damp
Bad Edges
Burnt
etc etc

In Row C7:Y7 is the total No of Damp boards
In Row C8:Y8 is the total No. of Bad Edges
In Row C9:Y9 is the total No. of Burnt boards
etc etc

Is it possible to sum all NON Blank totals and display them in a MsgBox
when a button is pressed.

E.G this would appear in message box

Damp 250
Bad Edges 100

Total No3's = 350

Hope you can help

Peter