# Counting the first instance

#### Iain McBride

##### New Member
Hi guys,
Trying to calculate the instances of certain occurrences happening.
Count EVERY 1 to 1
Count first instance of Group 1, 2 and 3
Do not count Absent:

I want to calculate it at the bottom of the range B5:B16 (so in cell B17).

can get certain aspects of the formula but not fully working,

Thanks,
Iain

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### Peter_SSs

##### MrExcel MVP, Moderator
From the little you have given us it is impossible to know what you have, where and what you are trying to do.

I'd suggest posting a small set of dummy data and the expected results and explain again in relation to that data. My signature block below has suggestions to help with that.

#### Iain McBride

##### New Member
 Here is a quick snap shot of my table: Column1 Date Date2 Date3 Date4 Name group 1 1 1:1 1:1 Name Group 1 0 Group 1 Group 1 Name Group 2 1 Group 2 Group 1 Name 1:1 1 1:1 Group 1 Name Abs 1 Abs Group 2 Name Abs 0 Abs abs Name Group 1 0 Group 1 1:1 Name Group 2 0 Group 2 1:1 Name Group 2 0 Group 2 1:1 Name Group 1 0 group 3 1:1 Name Abs 1 group 3 1:1 Name 1:1 1:1 1:1 Total Sessions 4 6 9

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>

So the table highlights that every 1:! is counted every first instance of a Group session is counted (the rest are not counted), and the Abs (absent) are not counted.

Hope that clear things (even just a little!)

#### Peter_SSs

##### MrExcel MVP, Moderator
See if this does what you want.
B14 is copied to D14 & E14

Excel Workbook
ABCDE
1Column1DateDate2Date3Date4
2Namegroup 111:11:1
3NameGroup 10Group 1Group 1
4NameGroup 21Group 2Group 1
5Name1:111:1Group 1
6NameAbs1AbsGroup 2
7NameAbs0Absabs
8NameGroup 10Group 11:1
9NameGroup 20Group 21:1
10NameGroup 20Group 21:1
11NameGroup 10group 31:1
12NameAbs1group 31:1
13Name1:11:11:1
14Total Sessions469
Count

#### Iain McBride

##### New Member

I have now been asked to add an element into the dropdown list (NMN - no meeting needed) that we are not counting (like the 'Abs'). Sadly I do not understand the above formula - can anyone help me to amend the formula.

Thanks
Iain

L
Replies
1
Views
68
Replies
3
Views
108
Replies
1
Views
85
Replies
9
Views
140
Replies
7
Views
76