LinkBack URL
About LinkBacks
is there a way to have a COUNTIF() function move from
COUNTIF(A:A,">5") to COUNTIF(B:B,">5")
without actually changing the A's to B's so it could be a recursive function?
is there a way to have a COUNTIF() function move from
COUNTIF(A:A,">5") to COUNTIF(B:B,">5")
without actually changing the A's to B's so it could be a recursive function?
Since its not absolute referenced, this change must happen automatically when you copy the cell containing the first formula into the adjacent cell - ex copying cell B1 containing "=COUNTIF(A:A,">5") " to C1 would have "=COUNTIF(B:B,">5")" in C1?
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
Just drag the formula to the next column/s, it will adjust itself automatically for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok that is all good but can I have that auto change in a formula so if I had a cell like C1=COUNTIF(D:D,">5")+COUNTIF(E:E,">5")+(COUNTIF(F:F,">5")....
I could just make a function that would start at column D and continued untill an empty column?
Hi,
Well if you know the last column then
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Ok, now what if i decide to be crazy and want every other column.. and lets assume I know how many. or both ways if you know how to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks