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
|