=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", <=DATE(2023, 1, 1), {Demand Opened Date}, >=DATE(2023, 12, 31))
Can someone help me figure out why it's not working?
Then this should be your formula:
=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", {Demand Opened Date},and(@cell>=DATE(2023, 1, 1), @cell <=DATE(2023, 12, 31)))
@DeMetria Hines
Not sure what you are trying to accomplish with the dates but you seem to be missing a {range} between "P&C Claims", and <=DATE(2023, 1, 1).
Is the below what you are looking for?
=COUNTIFS({Demand State}, [Primary Column]@row, {Investment Class}, "Grow", {Portfolio}, "P&C Claims", {Demand Opened Date},and(@cell<=DATE(2023, 1, 1), @cell >=DATE(2023, 12, 31)))
I am trying to count how many times [Primary Column]@row, when the Investment class is Grow, the Portfolio is P&C Claims, and the Demand Opened Date is between 01/01/23 - 12/31/23.
@Leibel S please see explanation above.
Thank you! That worked!
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.
