What I have is two columns. The first can contain any integer between 11 and 88. The second column has any positive integer value. What I want is a way of for each of the numbers in first column having a sum for the corresponding numbers in the second column. Attached is a spreadsheet which will hopefully make things clearer. I would like to do this if possible without using an array function or macros.
Many thanks,
Jack
F2 and down: =SUMIF($A$2:$A$11, E2, $B$2:$B$11)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
see the attached file.
Column G has the formula that gives you the result you want.
hope this helps.
modytrane
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks