Help with sum if formula

[SSSSSS123]

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 sums up and shows at J3?

i.e.

J5 (Consultant 4) should show the sum of G5 and G9

I know I can use the basic Sum formula however I am dealing with a spreadsheet of over 700 rows.

Thanks in advance.

[#2 · Accepted solution]

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