Forum Discussion

mandyb385's avatar
mandyb385
Copper Contributor
Aug 01, 2019
Solved

Excel: SUM values in a column if matching data in multiple other columns

Hello,   I would like to sum data in column L (genetic marker length) if the following conditions are met 1. Matching value in column D (sample ID) and 2. Matching value in column K (genetic mar...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Aug 02, 2019

mandyb385 

The formula in E2 of the attached file is: 

=IF(COUNTIFS(A2:A$21,A2,B2:B$21,B2)>1,
"",
SUMIFS(C$2:C2,A$2:A2,A2,B$2:B2,B2))

  • mandyb385's avatar
    mandyb385
    Copper Contributor
    Aug 06, 2019

    Thank you so much Twifoo! It works like a charm in my Master Spreadsheet. You're a lifesaver.

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Aug 06, 2019
      Your thanks sound a charm, too!

Resources