Forum Discussion

SSSSSS123's avatar
SSSSSS123
Copper Contributor
Oct 21, 2019
Solved

Help with sum if formula

Hi, I've been struggling with this for a few hours:   How can I set up a formula in which where if the consultant’s name in coulomb A matches either I4/I5/I6/I7, the value stated under coulomb G s...
excel
Formulas and Functions
  • tauqeeracma's avatar
    tauqeeracma
    Oct 21, 2019

    Hi SSSSSS123 

     

    You can use below Sumif() function to achieve your requirements:

    =SUMIF($A$2:$G$9,I4,$G$2:$G$9)

    Sample file is also attached for your reference.

     

    Thanks

    Tauqeer

     

     

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Oct 21, 2019

Hi SSSSSS123 

 

You can use below Sumif() function to achieve your requirements:

=SUMIF($A$2:$G$9,I4,$G$2:$G$9)

Sample file is also attached for your reference.

 

Thanks

Tauqeer

 

 

Resources