Top Posters
Since Sunday
g
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
s
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
JohnAmera JohnAmera
wrote...
Go to Answer
Posts: 432
Rep: 0 0
6 years ago
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

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 796 times
4 Replies
Exploring Microsoft Office Excel
Replies
Answer verified by a subject expert
zatan_zazatan_za
wrote...
#1
Posts: 265
Rep: 13 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

wrote...
#2
4 years ago
 ok
wrote...
#3
4 years ago
thanks
wrote...
#4
4 years ago
don't trust these answers, generally speaking.
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  776 People Browsing
 121 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 269
  
 1031
  
 301
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 308
Previous poll results: Which of the following is the best resource to supplement your studies: