Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting round the sensitivity of "sumif" formula
When using 'sumif' formula, if the data i am suming is in another file, i
will get error msg if i do not open the 2 files at the same time. Is there another function i can use that would allow me to acheive the same result without using 'sumif'? i tried 'vlookup' but it does not add up. Thanks so much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting round the sensitivity of "sumif" formula
=SUMPRODUCT('[workbook name.xls]sheet name'!$A$2:$A$8="value",'[workbook
name]sheet name'!$C$2:$C$8) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Xueling" wrote in message ... When using 'sumif' formula, if the data i am suming is in another file, i will get error msg if i do not open the 2 files at the same time. Is there another function i can use that would allow me to acheive the same result without using 'sumif'? i tried 'vlookup' but it does not add up. Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif formula that uses "contains" rather than "equals" | Excel Discussion (Misc queries) | |||
How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro | Excel Discussion (Misc queries) | |||
How do I test values in 2 different columns in a "sumif" formula? | Excel Discussion (Misc queries) | |||
How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions |