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(OFFSET(6m,0,2,"£",OFFSET(6m,0,2),0),0)))
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), "*£*")
