Dear All
I have a table where I need to build sumproducts, but only if 2 criteria are met.
The formula using one criteria only is:
=Sumproduct(B:B=B2)+0;K:K;H:H)
Column B: years (sum if year equal)
Column c: company name (2nd criteria: in equal years sum if company is eaqual)
Column K: amount
Column h: percentage
Of all the entries, I want to multiply K*H for each entry and display the total across all entries with same year/company
Hope this makes sense
Best regards
Sandra
Bookmarks