# 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:

Tags:

• Employee

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

October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭✭✭

You will need a criteria for the first range.

• Employee

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

October 8 - 10, Seattle, WA | Register now

• Thank you both! Closed out and solved :)

• ✭✭✭✭✭✭

Thanks for clarifying @Genevieve P.

@Matthew Miu Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!