| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum product
I'm using the following sumproduct formula to look up two pieces on
information on a spreadsheet and then return the text that is in column A but keep getting a #value! error. All the formatting is set to general so I'm not sure what I am doing wrong. Any advice? =sumproduct(('Tab1'!B2:B1199=A3)*('Tab1'!C2:C1199= B3)*('Tab1'!A2:A1199)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
| Percentages | Charts and Charting in Excel | |||
| How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
| Which function(s)? | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
Threaded Mode
