Hi wondering if anybody can help me with the following:
How can I get the "Analysis by Donor" table found on the worksheet "Donor Analysis" to sum by donor the amount of boxes under the 3 different categories from the worksheet "Others".
Regards
Hi wondering if anybody can help me with the following:
How can I get the "Analysis by Donor" table found on the worksheet "Donor Analysis" to sum by donor the amount of boxes under the 3 different categories from the worksheet "Others".
Regards
Hi there. There was a stray space at the end of Food in "Others" (fixed). There was an error in the cumulative total formula (fixed). I used an Array formula to return a unique list of donors, sorted alphabetically. I used a Named Range to make this dynamic as more conors are added on. I then used SUMPRODUCT to return the total you wanted. Adjust the range of SUMPRODUCT as needed.
Array Formulas are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly braces yourself - it won't work...
Last edited by Glenn Kennedy; 06-14-2015 at 05:23 AM.
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
Another version .....
One more version!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks