Hi,
Do you have Excel 2007 or later? If so you may find SUMIFS() work better than the SUMPRODUCT.
However upload your workbook so that we can see in context. I see your comparing values in a horizontal range with numbers in a vertical list but can't quite see what results are required.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks for the reply - I am using Excel 2003.
I have uploaded an example below.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks