countif column values based on a monthly value

ALAN.ROSSNEY
ALAN.ROSSNEY ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi,

 

I am creating a table of count of values in a column based on what month is reported in another. the table I want is attached. The formula I am using is as below. Can anyone advise what need to change in the planned formula

=SUMIF{V2.0 Eirabot - Gantt Range 1}},"12", {V2.0 Eirabot - Gantt Range 1}

I also want to have an actual row beneath. I have found issues where the two different calcs are providing the same values. The fact that smartsheets demotes a random range name rather than a pre-defined column name makes it difficult to reconsiliate. Any advice?

regards

 

Alan

 

countif.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!