Hi guys,
in row 2 i have a load of different shifts agents work
10-7, 11-7, 9-5, 11-8, 12-8. 9-6, 9-7
is there a forumla i can use to work out how many times the 7 appears only?? even though it says 9-7
Hi guys,
in row 2 i have a load of different shifts agents work
10-7, 11-7, 9-5, 11-8, 12-8. 9-6, 9-7
is there a forumla i can use to work out how many times the 7 appears only?? even though it says 9-7
Hello,
with the values above in cells A1 to F1, you could use
=SUMPRODUCT(--(NOT(ISERROR(FIND("7",A1:F1)))))
cheers,
or use
=SUMPRODUCT(--(ISNUMBER(FIND("7",A1:F1))))
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks