Countif function

Matthew Miu

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!

Genevieve P.

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

Paul Newcome

You will need a criteria for the first range.

Genevieve P.

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

Matthew Miu

Thank you both! Closed out and solved :)

Paul Newcome

Thanks for clarifying @Genevieve P.

@Matthew Miu Happy to help. 👍️