Need to make this simpler.

[Jack]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


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

 

[Guest]

Thank you very much. I completely overlooked that function
and it works perfectly.
Thanks again,
Jack