Can I have help with Multi COUNTIF

[Mettaya1]

I currently have this equation =COUNTIF($EZ29:$GD42,"TTMU")+COUNTIF($EZ29:$GD42,"TTMC")+COUNTIF($EZ29:$GD42,"TTMI")
Which works fine.

Was wondering if there was an easier way of doing this as typing it in is slow going when this is used month by month over a specific range.

Would a LOOKUP do this easier and if so how would it work.

Regards

Mettaya1

 

[Mettaya1]

I'll have a look at this.... was wondering if I include multiple types of Audits.
i.e.
HSC, HSI, HSU
TTMC, TTMI, TTMU
EMC, EMI, EMU
QAC, QAU, QAI

Would this still work?

 

[Mettaya1]

I'm actually looking for a count of a specific type of audits over a month date range that I can select easily by name as per your example.
The types of audits in a range would be as per your example but there are a number of audit types as per my last post.

I should end up with something like this

A1 A2 A3 A4 A5 A6 A7 A8
101
2
3
4
5
6
7
8
9
10
11

 

[Mettaya1]

<tbody>
[TD="class: xl77"][/TD]
[TD="class: xl77, width: 89"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 31"][/TD]
[TD="class: xl77, width: 31"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 29"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 39"][/TD]
[TD="class: xl77, width: 39"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 46"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 39"][/TD]
[TD="class: xl77, width: 39"][/TD]
[TD="class: xl77, width: 46"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl77, width: 36"][/TD]
[TD="class: xl92, width: 49, align: right"] Jul-13
[/TD]
[TD="class: xl85, width: 46"][/TD]
[TD="class: xl81, width: 39"][/TD]
[TD="class: xl81, width: 39"][/TD]
[TD="class: xl83, width: 46"][/TD]
[TD="class: xl83, width: 65"][/TD]
[TD="class: xl84, width: 41"][/TD]

[TD="class: xl93"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl80"] HS
[/TD]
[TD="class: xl80"] TTM [/TD]
[TD="class: xl80"] EM [/TD]
[TD="class: xl80"] QA [/TD]
[TD="class: xl80"] SEMS [/TD]
[TD="class: xl80"] SiteSafe [/TD]
[TD="class: xl80"] Joint [/TD]

[TD="class: xl78"]LS[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl78"]Crews[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77, align: right"]8[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77, align: right"]2[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl78"]Higgins[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl78"]HEB[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl78"]TIL[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77, align: right"]7[/TD]
[TD="class: xl77, align: right"]1[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77, align: right"]2[/TD]
[TD="class: xl77, align: right"]2[/TD]
[TD="class: xl77"][/TD]

[TD="class: xl78"]ECO[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77, align: right"]1[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77, align: right"]3[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]

[TD="class: xl78"]Directionz[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"]ITS[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"]Onsite[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"]Greenscenenz[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"]Spill Response[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"]Concrete Cutters[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"]TWC[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]

[TD="class: xl78"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl86, align: right"] 16
[/TD]
[TD="class: xl87, align: right"] 1 [/TD]
[TD="class: xl88"][/TD]
[TD="class: xl89"][/TD]
[TD="class: xl90, align: right"] 7 [/TD]
[TD="class: xl91, align: right"] 2 [/TD]
[TD="class: xl94"][/TD]

</tbody>

This is what I am looking for as a summary month by month. The table you created is a good look alike for the main data input.
Hope this is more clear.
Sorry for the unclear request earlier.

Regards

Mettaya1