LinkBack URL
About LinkBacks
Hi
I am trying to use a formula to count the number of cells between i9 and i158 containing the text "UK" however I need it to exclude any which have a date in the same row between c9 and c158.
Anyone able to help?
Much appreciated
Hi
I am trying to use a formula to count the number of cells between i9 and i158 containing the text "UK" however I need it to exclude any which have a date in the same row between c9 and c158.
Anyone able to help?
Much appreciated
Try this:
=COUNTIFS($I$9:$I$158,"UK",$C$9:$C$158,"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Great that works thanks, I just missed the $ signs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks