Quote:
Originally Posted by Spencer101
Hi,
Have a look at the attached for one way of doing what I think you need.
You didn't stipulate which version of Excel you're using so I've included a SUMPRODUCT approach that will work on any version of Excel and a SUMIFS version that will work in 2007 or later.
Let me know if you need any of it explaining further.
|
Thank you Spencer for your help! I'm afraid I'm not super experienced with SUMIF functions, but your approach seems good and I love a reason to learn something new! Thanks again for taking time to respond to my problem! :)