Recent Posts • Latest Topics • Unanswered Questions

This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of Gold ...

JohnAmera

wrote...

Go to Answer

Posts: 432

Rep:

6 years ago

This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of Gold ...

This is the first 4 lines of an excel list of 3082 records.
Which formula counts the number of Gold Level Members in the entire list?
   A   B   C   D   E
1   Level   Last Purchase   First Name   Last Name   Market
2   Silver   12/1/2016   Tanya   Smith   Tupelo
3   Gold   12/3/2018   Martha   Forester   Minneapolis
4   Platinum   12/8/2019   Thomas   Cord   Lakeland

A) =COUNTIF(A2:A3083,"Gold")
B) =COUNTIFS(A2:A3083,"Gold")
C) =COUNTIF(E2:E3083,"Gold")
D) =COUNTIFS(A2:E3083,"Gold")

Textbook

Exploring Microsoft Office Excel 2016 Comprehensive

Edition: 1^st

Authors: Poatsy, Mulbery, Davidson, Grauer

Read 809 times

4 Replies

Report

Exploring Microsoft Office Excel

Replies

Answer verified by a subject expert

zatan_za

wrote...

Posts: 265

Rep:

6 years ago

More solutions for this book are available here

Report

Related Topics

adrilee17

wrote...

4 years ago

1 Vote

Pooja Rai

Report

Benjamin D.

wrote...

4 years ago

thanks

Report

lalo12376

wrote...

4 years ago

don't trust these answers, generally speaking.

Report

New Topic

Quick Reply

Explore

Post your homework questions and get free online help from our incredible volunteers

1423 People Browsing

Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook

Live Chat

Related Images

398

467

951

Your Opinion

Previous poll results: Which of the following is the best resource to supplement your studies:

Courses by Biology Forums

The Toxic Skin and Fungi Defense

It's sore throat season, why does my mucus have red spots?

Bonobos, Chimpanzees, and the 98% DNA Link

Strange Ingredients Lurking in Doritos Chips

Ready to ask a question on Biology Forums? Try it out

Join Our Community

Biology Forums - Study Force is a free online homework help service catered towards college and high school students. Get homework help and answers to your toughest questions in biology, chemistry, physics, mathematics, engineering, accounting, business, humanities, and more. Master your assignments quickly with thousands of step-by-step solutions to countless textbook questions asked and answered by our members. If we don't have your question, don't worry. You can ask any homework question and get expert homework help in as little as two hours.

Our extensive online study community is made up of college and high school students, teachers, professors, parents and subject enthusiasts who contribute to our vast collection of study resources: textbook solutions, study guides, practice tests, practice problems, lecture notes, equation sheets and more. With our help, your homework will never be the same!

Join for free today

How is Biology Forums - Study Force different than tutoring?

Home Search Q & A Board Gallery Resource Library Blog Dictionary Chat	Quick Links Start a Topic Latest Topics Unanswered Questions Courses Study Tools Browse by Textbook	Social Facebook YouTube Community Stats Who's Online Trending Staff	Help About Us Take the Tour Study Tips Posting Guidelines Terms and Policies Contact Us
Biology Forums - Study Force © 2010-2024 \| Powered by SMF \| SMF © 2015, Simple Machines \| Sitemap Biology-Forums.com is not affiliated with any publisher. Book covers, title and author names appear for reference only.