When you are using a function such as COUNTIF, the syntax is =COUNTIF(Criteria_range, criteria). In general the criteria needs to be enclosed in double quotes.
What happens if you want to reference a cell as part of your criteria?
Say, in the above example, I want to count those whose % change is greater than the number in cell E10.
In this case, the formula needs to be =COUNTIF(D3:D8,”>”&E10)
Similarly if I had named cell E10, say as Target, the formula would be =COUNTIF(D3:d8,”>”&Target)
If I wanted to total the cells in Q2 where the % change was bigger than the number in cell E10, the formula would be =SUMIF(D3:D8,”>”&E10,C3:C8)
Find out more about our Excel training courses Sydney.