Dashboard Metrics
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?
Best Answers
-
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
-
You would include another range/criteria set along the lines of
……………,{Range}, @cell <> "None", ………………
Answers
-
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
-
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
-
It depends on what you are trying to do. Are you able to provide more details surrounding the expected logic and outcome?
-
@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:
-
You would include another range/criteria set along the lines of
……………,{Range}, @cell <> "None", ………………
-
@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.
-
@Paul Newcome Sorry, Paul. It's pulling the right amount. Thank you for your help!
Help Article Resources
Categories
Check out the Formula Handbook template!