How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jason Jones Your Own Question

Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 14405
Experience:  Over 10 years work experience.
30759776
Type Your Microsoft Office Question Here...
Jason Jones is online now
A new question is answered every 9 seconds

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

Customer Question

i need some help with a formula, dcounta...
Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Jason Jones replied 10 months 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 10 months ago.
i need to count the instances of each name, local 191 and the skill to the right.
Expert:  Jason Jones replied 10 months 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 10 months 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 10 months ago.
i thought it was dcounta
Expert:  Jason Jones replied 10 months ago.

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

Expert:  Jason Jones replied 10 months 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 10 months ago.

Hello,
Did that work for you?
- Jason

Customer: replied 10 months ago.
Thanks so much. A perfect solution !
Expert:  Jason Jones replied 10 months 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.