Excel Forumla

  recap 15:38 23 Mar 05

I am working on a spreadsheet that has a mix of alpha and numeric data in some columns and just alpha carachters in another. Within each column there are sub-headings that seperate certain information. I can do a filter for each sub-heading but cannot work out a forumla that would give me the data for the whole column.

The alpha/numeric data is an address line. The alpha data is the type of premise, say C for Church, W for Warehouse etc.

Is there a formula that will give me the total of just the data for each column without including the sub-headings?

  fsbb 16:30 23 Mar 05
  VoG II 16:53 23 Mar 05

Data/Subtotals and follow the wizard. It should give you a grand total at the bottom.

  recap 16:54 23 Mar 05

Thanks for the link fsbb.

  recap 16:55 23 Mar 05

Thanks VoG™, will give that a try tonight when I get home.

  recap 14:33 24 Mar 05

Thanks for the replies. I ended up using VoG™s suggestion.

This thread is now locked and can not be replied to.

How to watch Windows Event live stream, live blog | Microsoft event live stream: Watch Microsoft…

1995-2015: How technology has changed the world in 20 years

This amazing app turns your iPad Pro into a Cintiq

iPhone 7 Plus review: A superb big-screen phablet, but the price tag's enormous | iPhone 7 Plus…