Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max with Multiple Ifs
Hello All,
I need a Max statement with multiple ifs. Take for instance the example below, I need only the Max IF A=1 and C = 1. I've tried formulas like {=MAX(IF(Sheet1!A:A=A2, Sheet1!C:C, IF (Sheet1!E:E="yes", Sheet1!C:C)))} and {=IF(Sheet1!A:A=78, MAX(IF (Sheet1!E:E="yes",Sheet1!C:C)))}, but I've had no luck so far. So basically, for all values of A which are 1, I need the Max of B, if C is also 1, then for all values of A which are 2, I need the Max of B if C is 1, etc. Thanks, Chris Example: A B C 1 5 1 1 3 1 1 2 0 2 3 1 2 6 0 3 2 1 3 5 0 3 3 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
Transposing Multiple Cell References to Multiple Values (NOT total | Excel Discussion (Misc queries) | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) |