Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I understand how to do one condition, but I can't seem to find out how
to do two. Here is what I have for my current formula (it's doing a weighted average if you couldn't figure it out) =SUMPRODUCT(--($E$2:$E$10001=11), $I$2:$I$10001, $O$2:$O$10001)/SUMIF($E:$O,11,$O:$O) What I need it to also do is recognize a second criteria. I need it to somehow also do this: $G$2:$G$10001=2 If there is a better way to do this so it will pick up 11 and 2, I'm open for suggestions. Thanks Tyson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
COUNTIF using multiple conditions? | New Users to Excel | |||
Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) | |||
Summarize data with multiple conditions | Excel Discussion (Misc queries) | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions |