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).

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

PS Are you really using such an old version of Excel?

See if this sheet is at all helpful

H2:

=COUNTIF($B$2:$B$24,G2)

I2:

=SUMIF($B$2:$B$24,G2,$C$2:$C$24)

CF rule:

=I2>$J$15

applied to: =$I$2:$I$13

Alan - what have you used to do this?

This was a sheet I had from years ago from Debra Dagleish that I had kept in my files. It originated here: https://www.contextures.com/xlDataVal03.html

Ah, thanks.

@Ali--BTW, Left Coast is a common term to describe California. It has a double meaning as being on the left coast of the states and also for its left leaning politics.

It may be common in the US, but it meant absolutely diddly squat to me! Anyway, it's not important - just signifying the US is what matters.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

And thanks for the rep.