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

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&lt;[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