I have a formula here to count how many times a number appears in the list:
=COUNTIFS(B1:G--,"number to be counted")
The thing is, the top cell, "B1" is constant but "G--" is open-ended - that is, the more entries I add at the topmost row the cell reference for "G" will naturally be increased (or pushed down below the list).
Question: How can make "COUNTIFS" be able to count an open-ended cell reference under the "G" column?
NOTE: Was supposed to upload this under the "Formula..." category but I get this weird page aboiut "Succuri" firewall, saying my post has "objectionable HTML code". WTF?! I'm just uploading a question with the required Excel worksheet mandated by this forum.
Either there are some a*holes messing with my account in this forum OR there's this "someone" or "some group" messing with our net connection...
Update: Tried again to post under "Excel Formulas & Functions" for this concern and there it is again - "Access Denied - Sucuri Website Firewall". Reason posted in the bottom of the page:"Your request was not authorized due to its content (HTML code not allowed)."
F&*K! Is my post here just now "not allowed"? I think some a*hole is trying to mess up this very, VERY valuable forum.
Guess the admins need to check into this...
Bookmarks