I am using the countifs function but I only want to count values if a particular cell is populated wildcards don't seem to be working this is the formula =COUNTIFS('TOB Data'!$BJ$2:$BJ$1500,"*",'TOB Data'!$BQ$2:$BQ$1500,$L3,'TOB Data'!$BS$2:$BS$1500,M$2
Can you post workbook example to illustrate the problem, as wildcards work for my test.
Many thanks in advance
"*" will work for text content. Your cells contain a value, so use ">0"
For numerical values, you could also just use the COUNT function, thus negating the need for >0 or "*".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks