I have a tab set up with a set of short tables as a scratch pad to take an inventory of stuff.
My second tab needs to then summarize the totals for each table where there a tally exists. So I want to skip any of the scratch pad tables if it is blank (so my second tab doesnt have a bunch of zeroes)
For example, I want to take an inventory of my fridge, and end up with a second tab that just lists and counts the contents of my fridge.
On the first tab I have 20 short tables (say 10 rows long) and the tables are listed, eg, Apples, Cucumbers, Peaches, Pears, Potatoes, etc.
When i tally up my fridge, I count 6 apples, and I name them (lets just say I am insane and itemize them on the Apples table. At the top right of the Apples table is now a COUNT of "6" because I made 6 entries.
I skip the Cucumbers table because I am out of cucumbers
I go on the same way to list and count 5 Peaches, no Pears, and 4 Potatoes, etc.
On my Inventory Tab, I end up with just a list of items and counts, when there are entries on the previous tables.
e.g. I end up with:
A1 = "Apples" B1 = 6
A2 = "Peaches" B2 = 5
A3 = "Potatoes" B3= 4
The formula I am looking for on the second tab is something like:
"If Apples table total = 0 then skip it and go to the next table, else, A1= "Apples" and B1= the Apples table tally"