• 100% Satisfaction Guarantee
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 15173
Experience:  Over 10 years work experience.
30759776
Type Your Microsoft Office Question Here...
Jason Jones is online now

# I need some help with a formula, dcounta...

### Customer Question

i need some help with a formula, dcounta...
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Jason Jones replied 1 year ago.

Hello,

I am the person that will be helping you today.

May I ask for you to elaborate on what specifically you need help with?

I will be standing by.

Thank you,
Jason

Customer: replied 1 year ago.
i need to count the instances of each name, local 191 and the skill to the right.
Expert:  Jason Jones replied 1 year ago.

Thank you for the update. May I ask for you to elaborate a little bit on what you are trying to do? Please, give me a few examples.

Customer: replied 1 year ago.
there are 2 columns, name and skill name
i need a formulas that will look at that range of column d and e
and count how many times each name and skill occur.ie: local 191, down rigger = 7
local191, hand =?
Customer: replied 1 year ago.
i thought it was dcounta
Expert:  Jason Jones replied 1 year ago.

Thank you for the update. I will have this ready for you in a few minutes.

Expert:  Jason Jones replied 1 year ago.

The following command will show the results for "Local 191" and "Down Rigger":
=COUNTIFS(D:D,"Local 191",E:E,"Down Rigger")

The following command will show the results for "Local 191" and "Hand":
=COUNTIFS(D:D,"Local 191",E:E,"Hand")

I look forward to hearing your feedback concerning whether or not your problem is fixed.

I hope to hear back that all is working. If this is so, please do not forget to rate my help on the top of this page (choose the number of stars and click the Submit button). If it is not, please respond below.

I will be standing by,
Jason

Expert:  Jason Jones replied 1 year ago.

Hello,
Did that work for you?
- Jason

Customer: replied 1 year ago.
Thanks so much. A perfect solution !
Expert:  Jason Jones replied 1 year ago.

Thank you. Please, do not forget to rate my help on the top of this page. The only way I am given any credit for my time is if you rate my help.

Thank you.