| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Help
Hi
Currently I have the following string setup: =SUMPRODUCT(--('Awaiting Further Info'!B2:B294="NU"),--('Awaiting Further Info'!F2:F294="D"),'Awaiting Further Info'!I2:I294) I now also need this to check Column A for all instances of serial "1" but I cannot get the syntax right so grateful for your help. Column 'B' is Company, Column 'D' is Circuit Type and Column 'I' is cost of circuit per annum Thanks, Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
