Need to make this simpler.
 

Hello All,

I'm currently working on a spreadsheet for our President
and I'm trying to simplify my formula.

Basically I'm comparing each cell in a column to a specific
fixed cel and if they match I add the value contained in
cell that corresponds to each of the cels being compared.

My formula thus far:

=IF(J7=L1,H7,"0")+IF(J8=L1,H8,"0")+IF(J9=L1,H9,"0" )+IF(J10=L1,H10,"0")+IF(J11=L1,H11,"0")+IF(J12=L1, H12,"0")

As you can see this will be quite lengthy once I get
through all 200 cels. Is there a way to simplify this?

Thank you in advance,
Jack

Need to make this simpler.
 

=sumif(J7:J207,L1,H7:H207)

--
Regards,
Tom Ogilvy


"Jack" wrote in message
...
Hello All,

I'm currently working on a spreadsheet for our President
and I'm trying to simplify my formula.

Basically I'm comparing each cell in a column to a specific
fixed cel and if they match I add the value contained in
cell that corresponds to each of the cels being compared.

My formula thus far:

=IF(J7=L1,H7,"0")+IF(J8=L1,H8,"0")+IF(J9=L1,H9,"0" )+IF(J10=L1,H10,"0")+IF(J1
1=L1,H11,"0")+IF(J12=L1,H12,"0")

As you can see this will be quite lengthy once I get
through all 200 cels. Is there a way to simplify this?

Thank you in advance,
Jack

Need to make this simpler.
 

Thank you very much. I completely overlooked that function
and it works perfectly.
Thanks again,
Jack
-----Original Message-----
=sumif(J7:J207,L1,H7:H207)

--
Regards,
Tom Ogilvy


"Jack" wrote in message
...
Hello All,

I'm currently working on a spreadsheet for our President
and I'm trying to simplify my formula.

Basically I'm comparing each cell in a column to a specific
fixed cel and if they match I add the value contained in
cell that corresponds to each of the cels being compared.

My formula thus far:

=IF(J7=L1,H7,"0")+IF(J8=L1,H8,"0")+IF(J9=L1,H9,"0 ")+IF(J10=L1,H10,"0")+IF(J1
1=L1,H11,"0")+IF(J12=L1,H12,"0")

As you can see this will be quite lengthy once I get
through all 200 cels. Is there a way to simplify this?

Thank you in advance,
Jack


.