Forum Discussion
Link expansion creates to many characters in cell formula
Hello, I am using a sum-if-set formula (SUMMER.HVIS.SETT in norwegian) to access data in a excel file located in our network. When the file is open, the linking is short enough for the formula to...
SUMIF() doesn't work with closed file, both files are to be opened. You may use SUMPRODUCT() instead.
Thanks for the prompt reply!
This indeed works, but some of the compare in my data uses text that SUMIF() can cope with, but SUMPRODUCT() creates a unknown value in the array ({TRUE,TRUE,#VALUE!,FALSE,...}). Have to figure out a way to either remove the text cells, or find a way to use text (f.ex. my sample data may have 973010, 0389-30, 357892U as values to compare against, where both the latter are text).
THA_68 From this point of view I see no difference between SUMIF() and SUMPRODUCT(). To be more concrete it's better to see some sample.