Counting the first instance

Iain McBride

New Member
Joined
Aug 17, 2018
Messages
38
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,

Any help gratefully received.

Thanks,
Iain
 

Some videos you may like

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
Joined
May 28, 2005
Messages
46,175
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Aug 17, 2018
Messages
38
Here is a quick snap shot of my table:



Column1DateDate2Date3Date4
Namegroup 111:11:1
NameGroup 10Group 1Group 1
NameGroup 21Group 2Group 1
Name1:111:1Group 1
NameAbs1AbsGroup 2
NameAbs0Absabs
NameGroup 10Group 11:1
NameGroup 20Group 21:1
NameGroup 20Group 21:1
NameGroup 10group 31:1
NameAbs 1group 31:1
Name1:11:11:1
Total Sessions 469

<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
Joined
May 28, 2005
Messages
46,175
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Aug 17, 2018
Messages
38

ADVERTISEMENT

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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,516
Members
409,583
Latest member
gkarthick

This Week's Hot Topics

Top