How to lookup in two columns and do a sum from another column?
Reference attached screenshot.
The purpose is to calculate the total hours (Col 3) taught by Instructor A/B/C, etc. in Col 1 and Col 2.
Is there a formula or function that can do that? Or is there a better way to do this?
Thanks in advance for any guidance on the above.
Help Article Resources
Check out the Formula Handbook template!