Forum Discussion
Help please - Count / Count if?? with offset
I am trying to do where 6m is my date range - I want to only count the times £ appears in a cell and I cant get it to work . advice welcomed. Thank you COUNTIF(IF(AND(6m>=$R$3,6m<=$S$3), IF(OFFSE...
6m is not a valid reference. What did you mean by that?
HansVogelaar sorry for not being more specific - its my named range
It's confusing, since Excel won't accept 6m as a name, but I'll use it in the following. Replace it with the real name.
=COUNTIFS(6m, ">="&$R$3, 6m, "<="&$S$3), OFFSET(6m, 0, 2), "*£*")