Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello Bob - thanks a lot for yuor reply I was tring to use it, but I've the same problem I experienced befor posting the question (I get a #VALUE as result).. could be it is due t the fact that the area to which I apply the "SUMPRODUCT" function contains characters. To be more clear, I'm posting a copy of th spreadsheet with a more accurate sample. If you can have a look it would be great . thanks in adavance *pima +------------------------------------------------------------------- |Filename: example.zip |Download: http://www.excelforum.com/attachment.php?postid=4394 +------------------------------------------------------------------- -- pima ----------------------------------------------------------------------- pimar's Profile: http://www.excelforum.com/member.php...nfo&userid=538 View this thread: http://www.excelforum.com/showthread.php?threadid=51602 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using SUMIF inside SUMPRODUCT = complex problem (suite) | Excel Worksheet Functions | |||
Using VLOOKUP inside SUMPRODUCT = complex problem | Excel Worksheet Functions | |||
Complex SUMPRODUCT/VLOOKUP/SUMIF | Excel Worksheet Functions | |||
Sumproduct syntax - more complex | Excel Discussion (Misc queries) | |||
Help with Complex SUMPRODUCT formula | Excel Worksheet Functions |