Counting Error

Hello!

I made this awesome spreadsheet to count the hotel rooms per night to give to a hotel but when I go to summarize the column to count the totals I am getting an error. I think its because if a cell is blank for some folks the formula returns "invalid operation" which in turn effects counting the TOTAL cells to get the per night totals. Is there anyway to fix this or did I architect this in a way that I wont be able to get that answer.

Example of the formula for each column

=IF(AND([Check In City 1 All]@row <= DATE(2025, 10, 19), [Check Out City 1 All]@row > DATE(2025, 10, 19)), 1, 0)

Screenshot of the grid.

Find more posts tagged with

Accepted answers

Carson Penticuff

I believe the easiest solution would be to throw an IFERROR function around your formula so any error will return a blank cell.
=IFERROR(IF(AND([Check In City 1 All]@row <= DATE(2025, 10, 19), [Check Out City 1 All]@row > DATE(2025, 10, 19)), 1, 0), "")

All comments

Carson Penticuff

BrookeDawn

WOW - HERO that worked perfectly. Thank you!!!

Carson Penticuff

Happy to help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.