View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete[_4_] Pete[_4_] is offline
external usenet poster
 
Posts: 19
Default 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