Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FAO Mike
Hi Mike
Sorry to bother you again. Can you see the problem with this formula? I don't need to pick up a range of codes, I need a selection of different codes, but from the same data as before. This is returning zero as the answer. (Sorry it's long, but thought it was easier to send the whole thing!) =+SUMPRODUCT((Actuals!A2:A630=5010111)*(Actuals!A2 :A630=5010211)*(Actuals!A2:A630=5120111)*(Actuals! A2:A630=5200111)*(Actuals!A2:A630=5200211)*(Actual s!A2:A630=5260111)*(Actuals!A2:A630=5260211)*(Actu als!A2:A630=5400111)*(Actuals!A2:A630=5400211)*(Ac tuals!A2:A630=5400311)*(Actuals!A2:A630=5401211)*( Actuals!A2:A630=5440111)*(Actuals!A2:A630=5480111) *(Actuals!A2:A630=5640111)*(Actuals!A2:A630=564021 1)*(Actuals!C2:C630)) Thanks again Caroline |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mike H - Help | Excel Worksheet Functions | |||
Mike H - Help | Excel Worksheet Functions | |||
F.A.O Mike H | Excel Discussion (Misc queries) | |||
Help!!! MIKE H | Excel Discussion (Misc queries) | |||
Mike | Excel Discussion (Misc queries) |