+ Reply to Thread
Results 1 to 3 of 3

Trouble with calculations in Excel table

  1. #1
    Registered User
    Join Date
    07-10-2008
    Location
    Israel
    Posts
    5

    Trouble with calculations in Excel table

    Hey,

    I have a table of number sof high-rise buildings in the US (attached here). What I'm trying to do (with formula or code) is to compute how many buildings there are (in all the US) with 14 floors. How many with 15 floors. Etc. with each number of floors. I am beginner-level with VBA. I started by sorting everything according to number of floors, then writing a For loop to go through the rows and start adding the numbers, but I ran into trouble that I didn't know how to handle (know when it's the first instance of that number of floors in order to start counting anew form there, etc.). You can see my code (very preliminary) in the file.

    I need something like this (for all numbers of floors):

    14 floors - 400 (buildings)
    15 floors - 250
    ...


    After that, I also need to do the same thing, but this time divided by States, meaning:

    AK:
    14 floors - 100
    15 floors - 50
    (for each state and for each number of floors)


    I would be really glad for help with this issue.. too many little details that I'm not sure how to handle.
    Thanks a lot!

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit
    Posts
    401

    Re: Trouble with calculations in Excel table

    Cross-post:
    http://www.excelguru.ca/forums/showt...=8602#post8602
    http://www.vbaexpress.com/forum/show...in-Excel-table
    http://www.mrexcel.com/forum/excel-q...cel-table.html
    Last edited by rollis13; 07-30-2013 at 04:24 PM.

  3. #3
    Registered User
    Join Date
    07-10-2008
    Location
    Israel
    Posts
    5

    Re: Trouble with calculations in Excel table

    Thanks folks but I got help in another forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro Trouble with Automating Calculations
    By carden2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 03:58 PM
  2. Trouble with Calculations
    By Cuber in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-23-2010, 12:45 PM
  3. Trouble handling html table in Excel
    By deanes02 in forum Excel General
    Replies: 1
    Last Post: 09-21-2007, 07:40 AM
  4. how to import Ms word Table to Ms Excel for Various Calculations
    By Karthik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  5. how to import Ms word Table to Ms Excel for Various Calculations
    By reneabesmer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1