Discussion reply!!! about 75 words


For  this week’s discussion, I chose to cover the COUNTIF function in excel.  COUNTIF allows a user to automatically count particular criteria in the  desired range of cells (Microsoft, 2022). For example, I made a  worksheet with customer IDs and how much the customer has paid.  So, if I  wanted to see how many customers paid over $200 for instance, COUNTIF  would allow me to do so without having to go through and count each cell  myself.

the function for this example would  look like this =COUNTIF(B2:B200,”>199″). B1:B200 is the range of  cells I’d like to investigate, and “>199” is the “values 200 and  over” criteria I selected.


Additionally, If I wanted to make it a  bit easier to identify the customers that paid over $200, I could set a  New Rule under Conditional Formatting. For this new rule, I would  select the A column and it highlights any ID that has a paid value over  200 using the COUNTIF function (Spahic, 2021).



So, the COUNTIF function has helped me  identify how many customers paid over a certain value, as well as  helped me highlight the customer ID.


Microsoft. (2022, April 19). COUNTIF function.  Retrieved from support.microsoft.com:  https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34

Spahic, H. (2021, September 13). How to Use Countif with Conditional Formatting in Excel. Retrieved from excel.officetuts.net: https://excel.officetuts.net/examples/countif-in-conditional-formatting/

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.