Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

formula help

L@123[email protected] ✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts
06/30/17 Edited 12/09/19

I am attempting to get a formula to count a range if the column next to it has the correct category. for example

DF  1.1

DV  2.1

DF  3.3

DF  1.2

DV  2.1

I want to count how many numbers lay between 1 and 2 in the category DF, and am struggling to get the program to do this.  Any help would be appreciated.

 

Comments

This discussion has been closed.