I have a massive data dump from a client. Each row is a specific incident that: 1) occurred on a single asset, 2) either low, minor, major or serious level, 3) happened to an employee, customer or contractor, and 4) happened in 2018, 2019, 2022, and 2023.
What is the most efficient formula to use in order to count each single incident, for example (this is what I need): how many - low risk incidents happened on asset A to an employee in 2018?
All need to be counted, COUNTIFS function not work

Hi all

My joining will be on 19th Dec for Bangalore location Prestige Trade Tower. I'm looking for guys who need room partner. I'm ready to spend 10-15k for sharing in a rented apartment/house.

Please let me as soon as possible. Thanks

I can still opt for Pune location if somebody living in Pune.

Anybody know if there’s a Toronto Lawyers bowl?

There’s an Art Director at my job who helped with a new business pitch and came up with the WORST headline construct without consulting me or any copywriter. (Cont)

Can anybody tell me does BOSCH support buyout option? Should a candidate serve 3 months of notice period strictly?

Is paying a career coach worth it? $4000-$5000. I was looking at Madeline Mann. How true are the success stories?

Tell day 8th Nov!

Do any retail workers out there still get severe anxiety when you see someone without a mask?

I heard from my head that there is a lot of slowdown in VW Germany... There is Hiring freeze, level freeze and all ... And soon that will spillover to india. So be prepared for very less hikes in coming cycle :( Also automotive sector in general is struggling with tesla laying off 10% workforce recently. Maybe time to make a move? What do you say fishes?

Hi what is the maximum salary that can be provided in Verizon for the role 'Senior Engineer Consultant-QA Test Automation' ?

27 F, Indian, Sunni Muslim, In USA from last 6 years. Works at Deloitte.

Open minded, eat halal, non-smoker, non- hijabi. Love to travel. Pray, Fast and give Zakah on regularly.

Willing to relocate anywhere in USA.

Which MPLS agencies have strong account leadership?

I’ve worked at a few shops and have encountered maybe 2-3 account mgrs who worked to sell good work and protect timelines. Lots of box-checking.

For those who have passed the CIPM exam, what is it like (and how does it compare to the CIPP/US exam)?

Hi everyone, can you share the ideal salary range for an executive search professional with 10 years of experience?

How's the hours, barriers to entry, and scene in general for consulting here in Singapore? Considering a career change but could only find info on US/EU

Does anyone want a ticket to the Mets/Phillies game

How closely do pwc consulting work with s&? And how common is cross staffing onto s& projects?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Still don't have xlookup. #fomo

Would anyone be willing to teach me vlookup?

Best websites to get more of a handle on Excel as a beginner-intermediate?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.