hi all.. appreciate any help on my problem.
from the attached photo of excel values, i need to total values for each sector to the right, under A, B, C.
Capture.JPG
hi all.. appreciate any help on my problem.
from the attached photo of excel values, i need to total values for each sector to the right, under A, B, C.
Capture.JPG
Try this in L3 and copied right:
Formula:Please Login or Register to view this content.
BSB
Welcome to the forum!
Try this in L3:
=SUMIF($B$3:$J$3,L$2,$A$3:$I$3)
Drag copy to M3 and N3.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi, welcome to the forum
It's almost always better to upload a file, rather than show a pic - we cant really work with pics.
However, try this...
=SUMIF($B3:$J3,L$2,$A3:$I3)
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
wow is there an echo in here?
lol
problem solved!
thank you all so much for the help. i have 15,000 rows of data to work on
Happy to help
Ditto (or should that be "echo"?).
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks