Need help on countifs formula

Hi to everyone!

Appreciate to help me out to figure out why below formula is incorrect arguement?

=COUNTIFS({OPEN PR list Range 9}, [Primary Column]@row, {OPEN PR list Range 13}, <=DATE(2024, 4, 1), {OPEN PR list Range 13}, >=DATE(2024, 4, 30))

If i use no date range it works.

This is how the data file looks like

I wanted to count how many the purchaser has done based on the date range which monthly.

Thank you and awaiting anxiously.

Find more posts tagged with

Accepted answers

All comments

Mark.poole

@RobertZapata

After looking at your formula you have the < and > in the wrong locations. The way you have it you are looking for a date that's less then 2004,4,1 and also greater then 2004,4,30. There is no date that would exist in that range. Try.

=COUNTIFS({OPEN PR list Range 9}, [Primary Column]@row, {OPEN PR list Range 13}, >=DATE(2024, 4, 1), {OPEN PR list Range 13}, <=DATE(2024, 4, 30))

Itai Perez

Hi @RobertZapata

Did you try leaving only the date arguments to see if it works?

Are all the ranges the same size? They all use a full column?

I ran a test and it seems to work for me but I am probably missing something.

RobertZapata

Hi @Itai,

Thank you for the comment but i did it as you can see below it works but when i add purchaser name it is telling me the incorrect arguement?

I am really confused why i could not have these 2 arguements to work together.

Genevieve P.

Hi @RobertZapata

Can you double check that both of your {ranges} are in the same sheet and the same length?

https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--incorrect-argument-set

This error message can appear if your ranges are different lengths. I would suggest edit each reference and click the column name so all rows are selected. Let us know if that works for you!

Cheers,
Genevieve

RobertZapata

Hi @Genevieve P. ,

Yes both ranges are in one reference sheet.

Genevieve P.

Hi @RobertZapata

It's good that they're on the same sheet, but can you confirm they're the same length?

For example, if {list purchaser 9} is referencing rows 1-5, but the {Date} reference is from rows 1-10, then you'll get an error. They have to have an equal number of rows in each reference.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.