I want to do a countifs formula, but I want the range to be whole column B except B43. What should I put in the formula?
I want to do a countifs formula, but I want the range to be whole column B except B43. What should I put in the formula?
if you want to exclude B43 from the countifs, just do your countifs and subtract 1?
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
Actually my formula was =COUNTIFS($B:$B, "New Agent Training",$G:$G, "12"), but unfortunately it was also on column B so it couldn't work, and I dont want to move it. Any other ways to do it?
I dont see why =COUNTIFS($B:$B, "New Agent Training",$G:$G, "12")-1 wouldnt work?
that assumption is that b43 is going to be counted as 1
what is actually in b43?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
good point hum, I actually did think about that, then forgot lol
=COUNTIFS($B:$B, "New Agent Training",$G:$G, "12")-counta(B43) perhaps?
counta(b43) is always going to be 1
you need something like
COUNTIFS($B:$B, "New Agent Training",$G:$G, "12") -COUNTIF(B43,"New Agent training")
it will only be 1 is its not empty
let me rephrase......counta(b43) will be 1 if "anything" is in that field
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks