# Formula to add specific data

#### smpaz7467

##### Board Regular
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???

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
you need to use the sumif option.

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

This should sum all the values specific to Jack.

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?

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.

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"))

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

Replies
7
Views
290
Replies
0
Views
165
Replies
3
Views
232
Replies
2
Views
368
Replies
3
Views
234

1,219,941
Messages
6,151,082
Members
451,007
Latest member
gianmatt

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back