![]() |
|
#2
|
||||
|
||||
|
The average is given by
Code:
=AVERAGEIF($A$1:$A$15,"=6",$B$1:$B$15) Summing values in N Code:
=SUMPRODUCT(($M$1:$M$10="gen")*($N$1:$N$10))
__________________
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
SUMIF results changed based on filters
|
SteveBump | Excel | 5 | 10-29-2013 07:25 AM |
| Help! 'SUMIF' Formulas | dave1372 | Excel | 2 | 09-08-2011 07:05 AM |
SUMIF Formula question
|
jcaswell | Excel | 3 | 05-22-2011 02:52 AM |
Need Help With SUMIF Formula In R1C1 Style
|
Todd | Excel | 9 | 02-27-2010 08:30 PM |
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |