| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I know this is obvious but ..
An alternative .. try something like this, normal ENTER, copied down:
=LOOKUP(2,1/(P$2:P$10=P2)*(Q$2:Q$10<"Fixed Price"),X$2:X$10) Adapt the ranges to suit -- Max Singapore --- "Bony Pony" wrote: SUMPRODUCT(MAX((A1:A7="north")*(B1:B7="high")*C1:C 7)) from another post by Gary's student. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot activate smart tags - tried all the obvious | Excel Discussion (Misc queries) | |||
| A Really Stupid Obvious Question that is Driving Me Nuts | Excel Discussion (Misc queries) | |||
| Not so obvious Chart? | Charts and Charting in Excel | |||
Threaded Mode
