Hi comms
I'm trying count values in table which is populated by visited places - in column B, D, F, H, J.... and right to them in C,E, G, I, K these places should be counted based on WHOLE month. At this moment I can only count places in particular day (I mean in area of one color) but I cant figure out how to set in countif formula the range: range is non-continous area (from B7 to J36) but then using countif formula excel throw error about cyrcular references and cannot execute it. I tried too name range ( whole columns B, D, F, H, J and named it) then used this name in countif formula but same error I must keep in mind that these structure must be like now (no allowed to put all places in one column and make simply countif on whole single column - it would bee too easy) In attachment I put example.
Bookmarks