Summing data based on date range

SUMIFS(Raw Data::Table 1::G,Raw Data::Table 1::A,">="&DATE(2025,11,11),Raw Data::Table 1::A,"<="&DATE(2025,11,30))

When you copy/paste this formula the first reference will convert to "No of Guests". I don't use the Numbers setting "Use header names as labels", one reason being that you often get a mix of regular cell references and others that have names and it is a little confusing.

On the iPad, where header names are always labels, your formula could look like this:

Or, perhaps easier, you could just let a Pivot Table do the work. No formulas! Just a few clicks.

Add an 'Early' column to the data table:

For convenient entry on the iPad this could be formatted as Pop-Up Menu something like this:

Tap in the data table, then tap Cell > Create Pivot Table > Pivot Options and do something like this:

You can do a lot more than sums with Pivot Tables. And you can have multiple Pivot Tables based on the same data table, to give you different summary statistics.

When you update/add data just choose Cell > Refresh Pivot Table.

SG

The table in your first screenshot has 7 rows of data but none of the dates meet the criteria so the result should have been 0 for the table you posted. I can't say why a new row which has a date in the correct range and a non-zero number of guests would still sum to 0. One possibility is an error in the formula when you retyped (?) it into your table There are some other possibilities, too, but none really stand out:

SUM, SUMIF, and other numeric functions may result in 0 or an incorrect result is if the cells/ranges being summed have text-formatted numbers in them. Your numbers are aligned to the right of the cell like actual numbers (text naturally aligns to the left, numbers to the right) so this probably is not the problem here. Another could be the dates in column A have the year 0025, not 2025. That is also unlikely because Numbers will interpret a typed-in 2-digit date of 00 through 49 as 2000 through 2049 (50-99 will become 1950 through 1999).

Do try the Pivot Table. Takes literally seconds. Pivot Tables are especially good at aggregating values by date. They can do that automatically by week, month, year, day of week, etc., or by custom range using a helper column as in my example. No formulas to debug! Just click and drag.

SG