Top Posters
Since Sunday
6
l
6
n
5
N
5
m
5
s
4
4
4
r
4
m
4
4
s
4
New Topic  
JohnAmera JohnAmera
wrote...
Posts: 432
Rep: 0 0
A year 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


Edition: 1st
Authors:
Read 429 times
2 Replies
Exploring Microsoft Office Excel
Replies
Answer verified by a subject expert
zatan_zazatan_za
wrote...
Posts: 265
Rep: 3 0
A year ago
Sign in or Sign up in seconds to unlock everything for free.
A
1

Related Topics

wrote...
3 weeks ago
 ok
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  114 People Browsing
 174 Signed Up Today
Your Opinion
Where do you get your textbooks?
Votes: 110

Previous poll results: Do you believe in global warming?
Related Images
 417
 831