Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a simpler way to do this formula? | Excel Worksheet Functions | |||
VBA code simpler? | Excel Discussion (Misc queries) | |||
Complex formula vs. simpler | Excel Worksheet Functions | |||
How to run a macro many times simpler? | Excel Programming | |||
Lil Simpler | Excel Programming |