Formula to add specific data

[smpaz7467]

I need a formula to add up certain data. For example I have a spread sheet where we enter information in and the put the persons name. What I need is to add up the data thats put in by each person. Ex. data is in C2:C99. And the names are in F2:F99, so how would I add up all of Jacks information in Column C specifically put in by Jack???

 

[Legacy 68403]

you need to use the sumif option.

=SUMIF(F2:F99,"Jack",C2:C99)

This should sum all the values specific to Jack.

 

[Brian from Maui]

I need a formula to add up certain data. For example I have a spread sheet where we enter information in and the put the persons name. What I need is to add up the data thats put in by each person. Ex. data is in C2:C99. And the names are in F2:F99, so how would I add up all of Jacks information in Column C specifically put in by Jack???

What kind of data is in C2:C99?

 

[smpaz7467]

What kind of data is in C2:C99?

Numbers, I am adding up lot numbers in a different jobs, which is why I need to know how many lots each person is doing.

 

[Brian from Maui]

What kind of data is in C2:C99?

Numbers, I am adding up lot numbers in a different jobs, which is why I need to know how many lots each person is doing.

If you're summing, Damnnnn formula should work, if you're counting,

=SUMPRODUCT(--(ISNUMBER(C2:C99)),--(F2:F99="Jack"))

 

[smpaz7467]

I am adding all the lots. Works GREAT!!!! Thanks