Hi
I need to search in a row, and only count variables that have "yes" in cells that have a column heading containing the text "Device" (the names of the column headings themselves vary, but the ones I am interested in all contain the text "Device"). Is there a simple way of doing this? Thanks
Will a simple COUNTIFS work?:
Change the row ranges to match your "Yes" column and column headings accordingly.
Please Login or Register to view this content.
Hope this helps!
Last edited by mcmahobt; 11-20-2014 at 12:15 PM.
Spread the love, add to the Rep
"None of us are as smart as all of us."
You could try this:
=COUNTIFS(2:2,"true",1:1,"*Device*")
Hope that helps.
-Z
If I helped you, click * and add to my reputation.
I think that this is what you are looking for.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks