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 NewITZone Your Own Question

NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I'm a rookie at formulas. I'm trying to get a count of deals

Customer Question

Hi - I'm a rookie at formulas. I'm trying to get a count of deals <=10000 that is listed in one column based on certain criteria to specific values listed in another - The formula I've written below is giving me my total of 188 but only 20 meet the 10000 but <=30000. Help! Thank you
=COUNTIF('2016 Submitted'!K:K,"*Closed*")+COUNTIF('2016 Submitted'!K:K,"Non-Award")
Submitted: 4 months ago.
Category: Microsoft Office
Expert:  Jason Jones replied 4 months ago.


I am the person that will be helping you today.

May I take a look at your document and ask for a more in depth description?

Please, be forewarned that the site is not secure:
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
I will be standing by, looking forward to your response.

Thank you,

Customer: replied 4 months ago.
Ok. But I do not have access to my computer right now. I'll send later tonight. I was able to finally create a formula that worked but am curious to see if there is an easier way
Expert:  Jason Jones replied 4 months ago.

Thank you.