Thread: [Solved] Average if and sumif
View Single Post
 
Old 01-17-2014, 01:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
The average is given by
Code:
=AVERAGEIF($A$1:$A$15,"=6",$B$1:$B$15)
(you can refer to a cell value instead of hard-coding the value)
Summing values in N
Code:
=SUMPRODUCT(($M$1:$M$10="gen")*($N$1:$N$10))
Although you asked for a count the result you gave is the sum of the values.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote