Results 1 to 10 of 10

wedding reception spreadsheet: counting seats at tables (with sample)

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2019
    Location
    Left coast (California, USA)
    MS-Off Ver
    2003
    Posts
    1

    wedding reception spreadsheet: counting seats at tables (with sample)

    Hello all...

    We have spent a week of evenings beating on Excel and we just can't make a
    calculation work... (maybe Excel 2003 can't do it?)
    We are asking for help in making our wedding reception spreadsheet work...

    Please see the attached Excel file... We are assigning tables and would like to have a
    running total of seats per table...

    For each party invited we enter Column A (the names), column B (the table #) and
    Column C (the headcount per party).
    We have Column H working... However we can't figure out how to make Column I work.
    Column K shows what we would like to see.

    Having the cell turn red if the headcount exceeds the table size is not vital
    but would be an extra bonus.

    Thanks in advance.

    Sylvia & Mike (our wedding is on the 28th of this month).
    Last edited by Pepe Le Mokko; 12-07-2019 at 04:13 AM. Reason: Amended title. We know you are here for help

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Minimum number of tables/seats to be used dsitributing agents with 2 shifts
    By jmrc123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2019, 08:04 PM
  2. [SOLVED] Need a SUMPRODUCT Formula to Fit Sample Spreadsheet
    By snapfade in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2018, 07:15 PM
  3. Assigning Wedding Tables
    By Hunter911 in forum Excel General
    Replies: 2
    Last Post: 10-08-2014, 01:11 PM
  4. [SOLVED] Counting a sample (rows in a column) based on two criteria
    By Lija in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2013, 10:17 AM
  5. Shop Sample spreadsheet
    By hustla7 in forum Excel General
    Replies: 1
    Last Post: 08-29-2006, 04:22 AM
  6. Sample Code Request for Importing SQL Tables to Excel
    By Sandra Poh in forum Excel General
    Replies: 0
    Last Post: 05-16-2006, 12:00 PM
  7. rota for reception cover
    By ABBI in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-13-2005, 04:05 AM

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