Countif function

Ok so...trying to get this data from the source file below which feeds into the computation sheet below it to represent 3 graphs in my dashboard (Click total, Unique click, Opened) for each previous month....you can see my countif in the computation sheet but it errors out. Basically each leader i want a chart that shows month over month (bar) on how many of each of the three listed above.

Source file:


Computation Sheet:


Thank you in advance!

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Matthew Miu

    To clarify what Paul said, a COUNTIFS works like this:

    =COUNTIFS({Range 1}, "Criteria 1", {Range 2}, "Criteria 2"...)


    Your COUNTIFS formula is looking at two ranges: {Range 15} and {Range 16}.

    You note the MONTH to look for in {Range 16}, however you don't have a criteria for what it's looking for in {Range 15}.

    Try adding something simple like "is not blank" which would be <> "". This would count all the cells that aren't blank in {Range 15}, and are Today's Month in {Range 16}


    =COUNTIFS({Newsletter Reporting Source File Range 15}, <> "", {Newsletter Reporting Source File Range 16}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))


    Cheers!

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!