Coountifs with date

Netha Lawrence

Hello,

i have a excel sheet that has the formula of

=COUNTIFS(Alerts!A1:A693,">="&A11,Alerts!A1:A693,"<="&B11,Alerts!C1:C693,R6)

I am trying to do the same formula in smartsheets. This is what I have:

=COUNTIFS({Alerts Range 1}, >[Column13]4, {Alerts Range 1}, <[Column14]4, {Alerts Range 2}, [Column11]4)

What I want to do is count how many times a word is inputted from a date range.

Can some help out and what the correct formula should be?

Thanks

Find more posts tagged with

Comments

L_123

This looks correct. What is the error you are getting? We can simplify it a bit to

=COUNTIFS({Alerts Range 1}, and(@cell >[Column13]4,@cell<[Column14]4), {Alerts Range 2}, [Column11]4)

but that is an aethetic change rather than a functional one.

Have you double checked each of your other sheet references and made sure they reference the same number of columns, and that they didn't get undone after you submitted (this happens to me way to often).

Netha Lawrence

Thank you! The only problem is it's not counting the total. It's showing 0 for the total when there is at least 1 or more that it should count.

Andrée Starå

Hi Netha,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet Performance Issue
By when the issue will be resolved?
Unable to Access Smart Sheet
Hi, I'm currently experiencing an issue with Repair Tracking smartsheet, which was created about three weeks ago. When attempting to access it, the page takes an unusually long time to load and eventually displays the following error message: Interestingly, other Smartsheets I’ve created are working fine—this issue seems…
Cannot access my smartsheets