=SUMPRODUCT(SIGN((APR'!$A$3:$A$2500&APR'!$B$3:$B$2500="Place holder"&$B$2)*(APR'!$I$3:$I$2500<>"R")))
for the most part this formula works but in Collumn "I" I want to exclude Value "R", the problem is it is also excluding the value RBS which I don't want.
This has to be a sumproduct formula as it is referencing a closed workbook (I have shortened it for easy viewing removing the file location path)
Any Help will be much appreciated
solved was a data entry error, formula works xD
It doesn't seem to be that part of the formula that's causing the problem. I think...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
SIGN function is redundant in your formula - you can remove it and get the same results
=SUMPRODUCT((APR'!$A$3:$A$2500&APR'!$B$3:$B$2500="Place holder"&$B$2)*(APR'!$I$3:$I$2500<>"R"))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks