asked on
Excel lookup/formula help
I have a workbook with two sheets
BreakDown which has two key column
B Indusry
C which is Total ARR
Industries which has two columns
A Industry
B Total which should be the sum of BreakDown Column C for all matches of Industries(A)=BreakDown(B)
BreakDown which has two key column
B Indusry
C which is Total ARR
Industries which has two columns
A Industry
B Total which should be the sum of BreakDown Column C for all matches of Industries(A)=BreakDown(B)
Microsoft ExcelMicrosoft Office
Last Comment
zorvek (Kevin Jones)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
having and error
=SUMIF(BreakDown!B,Industries!A2,BreakdDown!C)?
=SUMIF(BreakDown!B,Industries!A2,BreakdDown!C)?
Please try my formula. It should go in row 2.
=SUMIF(BreakDown!B:B,Industries!A2,BreakdDown!C:C)
Kevin
Kevin
Kevin