Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: JohnAmera on Nov 17, 2017



Title: This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of Gold ...
Post by: JohnAmera on Nov 17, 2017
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")


Title: Re: This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of ...
Post by: zatan_za on Nov 17, 2017
Content hidden


Title: Re: This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of ..
Post by: adrilee17 on Sep 29, 2019
 ok


Title: Re: This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of ...
Post by: Benjamin DeRosia on Mar 27, 2020
thanks


Title: Re: This is the first 4 lines of an excel list of 3082 records.Which formula counts the number of ...
Post by: lalo12376 on Apr 7, 2020
don't trust these answers, generally speaking.