In Cell V15
Formula:
=SUMIF($B$15:$B$23,U15,$Q$15:$Q$23)
Adjust column range to meet your needs, then copy and paste down. The way your spreadsheet is set up the calcluations are done manualy (after each enter), if you want it to automatically calculate you'll have to change that in the calculation options.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks