Hello All
Please see attached.
I need a formula in column AD that will do the following.
- Look in columns AT, BH, BM, BO, and return ONLY the total count of cells that are blank, read "0", or "Assigned".
Let me know if you need further clarification
I hope that I have given a decent explanation of my issue. I apologize if I have titled a thread in a manner that is difficult to comprehend. At the end of the day, I believe I need some sort of count if help.
Please help
Maybe something like this: =SUM(COUNTIF(A1:A5,{"Assigned",0,""}))
Adjust it for your range
HTH
Regards, Jeff
This is my interpretation of what I think you are asking:
Enter this in AD5 and fill down.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Here's another one...
=SUM(COUNTIF(INDIRECT({"AT5","BH5","BM5","BO5"}),{"";0;"Assigned"}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks