| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct - number & text
Hi, I have number in colB & text in Col C,D
I was trying sumproduct to go the data from colD looking at Col B & C something like below.. But result is #VALUE! =SUMPRODUCT((Sheet2!$C$2:$C$100=$C$2)*(Sheet2!$B$2 :$B$100=R4)*(Sheet2!$D$2:$D$100)) Can someone help me on this pls... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| Sumproduct with both number and text formats | Excel Worksheet Functions | |||
| Sumproduct with either text of number format | Excel Worksheet Functions | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
| Sumproduct with different number formats | Excel Discussion (Misc queries) | |||
Threaded Mode
