I have three columns. One contains unique alphabetic codes. Two contains alphabetic category codes. Three contains the value of the relevant column one code
I need to be able to get category totals.
Thanks
I have three columns. One contains unique alphabetic codes. Two contains alphabetic category codes. Three contains the value of the relevant column one code
I need to be able to get category totals.
Thanks
Last edited by yoosed; 02-26-2012 at 07:29 AM.
in C19, add....
=SUMIF($B$4:$C$14,A19,$C$4:$C$14)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks, problem solved, but not sure how to add to your reputation or mark the thread as solved.
Click on the FAQ button , it's all there
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks