I am using the SUMIF to sum a column from a separate worksheet into the active worksheet. It returns 0 even though the criteria matches values in the range. I have attached a screen print of the fx function window. Can anyone tell me why it won't pull back the sum in the sum_range of 43212.91?
With Sumif() the other workbook must be open and then still maybe volatile.. try with Sumproduct
e.g. =Sumproduct(--(range=T9),sum_range)
filling in actual full range with path as required...
Does that give a better result?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks