Sumif function

Hi!

I need to sum up values in Sheet 2 column B based on the data that is in Sheet 1.

Please refer to the attached file.

thx
SumIf-formula.xlsx
LadkissonAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Try this ARRAY formula

=SUM(IF(ISNA(MATCH(A2:A24,Sheet1!$A$2:$A$7,0)),0,Sheet2!B2:B24))
0
 
LadkissonAuthor Commented:
no it did not work...it just gave me Total value for column B in sheet 2. Please see the attached file.
SumIf-formula.xlsx
0
 
Saurabh Singh TeotiaCommented:
You need to enter that formula by ctrl+shift+enter..

Alternatively you can simply enter this formula...

=SUMPRODUCT(ISNUMBER(MATCH(Sheet2!A$2:A$24,Sheet1!A2:A7,0))*(Sheet2!B$2:B$24))

by simple enter and it will do what you are looking for...

Your workbook attached...

Saurabh...
SumIf-formula.xlsx
0
 
LadkissonAuthor Commented:
Actually I did enter the combination of ctrl+shift+enter after I submitted my comment:) But it gave me a different answer too - $127.86 which is wrong....let me see if your suggested formula works...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.