why not just, assuming headers are in row 1, data starts in row 2...
=SUM(C1,IF(A2=B2,C2,0))
why not just, assuming headers are in row 1, data starts in row 2...
=SUM(C1,IF(A2=B2,C2,0))
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Posting Permissions
Reply With Quote