How to find all fields with X value and show corresponding Y value
 

Hello there, thanks in advance. I am quite sure this is simple but cant
figure it out.

Ok, My G4:G135 fields all have employee names

My F4:F135 fields all have the payment amount for that job

Now, I have 20 employee's through all these fields.

I want to find a certain employee in G4:G135 and find all of his payments,
then add them up to produce the total.

While this doesnt work, it should explain what I am trying to do:

=IF(G4:G140,"Jackson"), SUM(F4:F140 "Jackson")

As you can see, I am not too cluey on this. Please let me know if you need
further info or screenshot

How to find all fields with X value and show corresponding Y value
 

=sumproduct(($g$1:$g$5000="jackson")*($f$1:$f$5000 ))


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=570713

How to find all fields with X value and show corresponding Y value
 

Hi Richard,

use sumif()

In ur case : =SUMIF(G4:G140,"Jackson",F4:F140)

"Richard" wrote:

Hello there, thanks in advance. I am quite sure this is simple but cant
figure it out.

Ok, My G4:G135 fields all have employee names

My F4:F135 fields all have the payment amount for that job

Now, I have 20 employee's through all these fields.

I want to find a certain employee in G4:G135 and find all of his payments,
then add them up to produce the total.

While this doesnt work, it should explain what I am trying to do:

=IF(G4:G140,"Jackson"), SUM(F4:F140 "Jackson")

As you can see, I am not too cluey on this. Please let me know if you need
further info or screenshot

How to find all fields with X value and show corresponding Y v
 

Excellent, worked perfectly. Thank you very much

"Arjuna" wrote:

Hi Richard,

use sumif()

In ur case : =SUMIF(G4:G140,"Jackson",F4:F140)

"Richard" wrote:

Hello there, thanks in advance. I am quite sure this is simple but cant
figure it out.

Ok, My G4:G135 fields all have employee names

My F4:F135 fields all have the payment amount for that job

Now, I have 20 employee's through all these fields.

I want to find a certain employee in G4:G135 and find all of his payments,
then add them up to produce the total.

While this doesnt work, it should explain what I am trying to do:

=IF(G4:G140,"Jackson"), SUM(F4:F140 "Jackson")

As you can see, I am not too cluey on this. Please let me know if you need
further info or screenshot

How to find all fields with X value and show corresponding Y value
 

Activate the cell where you want to show the result, and write

SUMIF(G:G,"Jackson",F:F)

--
~roar


Richard skrev:

Hello there, thanks in advance. I am quite sure this is simple but cant
figure it out.

Ok, My G4:G135 fields all have employee names

My F4:F135 fields all have the payment amount for that job

Now, I have 20 employee's through all these fields.

I want to find a certain employee in G4:G135 and find all of his payments,
then add them up to produce the total.

While this doesnt work, it should explain what I am trying to do:

=IF(G4:G140,"Jackson"), SUM(F4:F140 "Jackson")

As you can see, I am not too cluey on this. Please let me know if you need
further info or screenshot