LinkBack URL
About LinkBacks
the following formula counts the word WO in a row
i want it to also count the work WL
so bascially want it to count WO & WL
=COUNTIF(M3:JS3,"wo")
the following formula counts the word WO in a row
i want it to also count the work WL
so bascially want it to count WO & WL
=COUNTIF(M3:JS3,"wo")
What about this..
http://www.excelforum.com/showthread...=1#post3411917
we are not here just to serve.. we also expect some return.. now its your turn..
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Marked as solved any one help with this?
olvedi see you marked your last thread as solved
try
=SUM(COUNTIF(M3:JS3,{"wo","wl"}))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks