Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
dagr8tim dagr8tim
wrote...
Go to Answer
Posts: 418
Rep: 0 0
6 years ago
This is the top three lines in a list of 8200 records. You want an average of the number of speeding tickets for Red Toyota Priuses. Which is the correct formula?
   A   B   C   D   E
1   Year   Make   Model   Color   Speeding Tickets
2   2016   Honda   Accord   Black   2
3   2018   Toyota   Prius   Red   0

A) =AVERAGEIFS(A2:A8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
B) =AVERAGEIFS(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
C) =AVERAGEIF(E2:E8201,D2:D8201,"Red",B2:B8201,"Toyota",C2:C8201,"Prius")
D) =AVERAGEIF(E2:E8201,"Red","Toyota","Prius")
Textbook 
Exploring Microsoft Office Excel 2016 Comprehensive

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 2489 times
24 Replies
Replies
Answer verified by a subject expert
anicidanicid
wrote...
#1
Top Poster
Posts: 694
Rep: 32 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here

Related Topics

wrote...
#2
6 years ago
Thank you!
wrote...
#3
6 years ago
thank you!
wrote...
#4
6 years ago
 Face with Open Mouth thanks
wrote...
#5
6 years ago
thank you!
wrote...
#6
6 years ago
Thanks.
wrote...
#7
6 years ago
Thank you!
wrote...
#8
6 years ago
thank you!
wrote...
#9
4 years ago
thank you!
wrote...
#10
4 years ago
Thanks
wrote...
#11
4 years ago
thanks
wrote...
#12
4 years ago
thanks
wrote...
#13
4 years ago
Thanks
  New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1357 People Browsing
 106 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 42
  
 1131
  
 893