i have yet another problem i want to sum totals in a small chart sumif (g6:g25,match g77, but also h6:h25 match h78 find the ones that match and sum up the totals from u6;u25
i have yet another problem i want to sum totals in a small chart sumif (g6:g25,match g77, but also h6:h25 match h78 find the ones that match and sum up the totals from u6;u25
I don't remember if 2007 has a SUMIFS function which should allow you to do mulitple matches for your SUM.....HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
yes ut does, it was intro'd in 2007
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
sssooooo how do i do it
enter =sumifs(and then follow the instructions.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks