Hello,
I think there is a simple solution that for my problem.
I am trying to sum numbers (in a column) based on two criteria.
I've attached an example of my problem with the end result I require.
Thank you in advance!
Hello,
I think there is a simple solution that for my problem.
I am trying to sum numbers (in a column) based on two criteria.
I've attached an example of my problem with the end result I require.
Thank you in advance!
Joe:
Paste this formula in cell C19 and copy down.
Paste this formula in cell D19 and copy down.=SUMPRODUCT(--(A$3:A$12=A19),(B$3:B$12=B19)*(C$3:C$12))
=SUMPRODUCT(--(A$3:A$12=A19),(B$3:B$12=B19)*(D$3:D$12))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks