This is one of the formulas I've tried.
=SUMIFS({Annual Billing Amount}, {Deactivated?}, 1, {Date to Deactivate}, ">=2/23/2022")
Thanks for your help!
Hi
This should work for you
=SUMIFS([Annual Billing Amount]:[Annual Billing Amount], Deactivated:Deactivated, @cell = 1, [Date to Deactivate]:[Date to Deactivate], @cell >= DATE(2022, 2, 23))
IF the Annual Billing Amount and Deactivated are ranges, then just replace them with the range identifier.
I hope that helps, please let me
Thank you! Using the formula you provided, I changed the ranges as follows because I was referencing another sheet, however still getting an unparseable error.
=SUMIFS([{Annual Billing Amountx}]:[{Annual Billing Amountx}], [{Deactivated?}:{Deactivated?}], @cell = 1, [{Date to Deactivate}]:[{Date to Deactivate}], @cell >= DATE(2022, 2, 23))
I am sorry, I have been and still am sick so my brain is foggy. However, the [{ and }] do not look like correct syntax:
'[ ] are used when a col. has spaces always good to use them as best practice just in case. so [col 1]:[col1] is correct syntax to use a full col.
'{ } are used when you reference a range so [Sheet Name Range Number} unless you rename the range which is also best practice. so {Name of the Range} is the correct syntax.
See if you can fix the syntax and let me know if it's a range you only need the range and not {range}:{range}.
I hope that helps and that I haven't misspoken.
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.
