OK, I stumped a couple of you yesterday, this one should be easier...
The following is working to show me sum of rows in R5:R3000 where A column equals "Argentina" for the entire range.
=SUMIF('Territory Report'!A$5:A$3000,"=Argentina",'Territory Report'!R$5:R$3000)
I want the sum of rows in R5:R3000 where A column equals "Argentina" for the range that appears after the filter is used.
Anybody?
Very similar to what I gave you yesterday, except you use Subtotal(9,...)
Please Login or Register to view this content.
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.
Thanks for your help - again!
Overdoit, please make sure you post in the appropriate forum as indicated in our rules, failure to do so in future will result in your post being locked!
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks