Dashboard Metrics

Canteaug

I am trying to pull the total of findings from another source sheet that allows multiple selections. My formula is not working like it should properly. Could someone help?

Paul Newcome

Your closing curly bracket } needs to go at the end of the range instead of after the criteria.

You have

{Range, criteria}

You should have

{Range}, criteria

Paul Newcome

You would include another range/criteria set along the lines of

……………,{Range}, @cell <> "None", ………………

Paul Newcome

Your closing curly bracket } needs to go at the end of the range instead of after the criteria.

You have

{Range, criteria}

You should have

{Range}, criteria

Canteaug

Hey Paul! Thank you for catching that. It's still pulling the wrong data. Why would that be? I don't usually have this issue using this same concept in past sheets. See below: @Paul Newcome

Paul Newcome

It depends on what you are trying to do. Are you able to provide more details surrounding the expected logic and outcome?

Canteaug

@Paul Newcome Hi Paul. I just realized I was using the COUNTM formula and not COUNTIf. It worked just fine when I changed it to COUNTIF. Thank you for your help with it! However, I do have another question. I am trying to pull data from another sheet by counting the number of counties in a cell only if there are findings associated with the county per cell, so we do a review on each county, but we don't always have a finding. I have column that specifies the type of finding. I don't want to count the cells that has the option "None". Here is what I have so far:

Paul Newcome

You would include another range/criteria set along the lines of

……………,{Range}, @cell <> "None", ………………

Canteaug

@Paul Newcome I tried this =COUNTIFS({State Office SNAP QC Review Range 1}, [Counties by Region ]@row, {State Office SNAP QC Review Range 3}, @cell <> "None", {State Office SNAP QC Review Range 2}, =DATE(2024, 3, 1)) and its pulling the wrong amount.

Canteaug

@Paul Newcome Sorry, Paul. It's pulling the right amount. Thank you for your help!

Paul Newcome

Happy to help. 👍️