Good afternoon,
I have a problem, i need to count the number times a given number occurs in a range of cells
Screen Shot 2013-09-01 at 12.11.04 PM.jpg
The problem lies in the fact that each cell there are two numbers separated by a comma. The first represents a activity code and the second is a user codes. I need to be able to pull out totals for each.
I am by no means an excel master, so please make this as simple as possible
Thank you in advance
Using your posted example, try these regular formulas:
H31: =COUNTIF($A$3:$P$27,G31&",*")
Copy that formula down through H33
K31: =COUNTIF($A$3:$P$27,"*,"&J31)
Copy that formula down through K33
Is that something you can work with?
yes, now lets say i need to count how many times i used 13,51. How would i set up that formula.
Thanks again
That's easier, since we're looking for a compete match.
G34: 13,51
Try this regular formula
H34: =COUNTIF($A$3:$P$27,G34)
Does that help?
Yes thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks