Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smarter Idea
Hi All,
I have to check if there is data in B1:B3 (for example the entry '12') if so, I need to add/sum the number that is written in the parallel cell in A1:A3. For example if in B1 = o,B2=12,B3=12 and in A1=1,A2=2,A3=3. then the total (represent in cell C1) will be 5. I accomplished that by using IF sentence for each entry. Is there a more smart way to do this? Thanks a lot in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smarter Idea
=SUMIF(B1:B3,12,A1:A3)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lp12" wrote in message ... Hi All, I have to check if there is data in B1:B3 (for example the entry '12') if so, I need to add/sum the number that is written in the parallel cell in A1:A3. For example if in B1 = o,B2=12,B3=12 and in A1=1,A2=2,A3=3. then the total (represent in cell C1) will be 5. I accomplished that by using IF sentence for each entry. Is there a more smart way to do this? Thanks a lot in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smarter Idea
Try this in C1:
=SUMIF(B1:B3,12,A1:A3) You can adjust the cell references for longer ranges, eg: =SUMIF(B1:B15,12,A1:A15) which you would not be able to do in your IF statements. Hope this helps. Pete On Mar 6, 9:19 am, Lp12 wrote: Hi All, I have to check if there is data in B1:B3 (for example the entry '12') if so, I need to add/sum the number that is written in the parallel cell in A1:A3. For example if in B1 = o,B2=12,B3=12 and in A1=1,A2=2,A3=3. then the total (represent in cell C1) will be 5. I accomplished that by using IF sentence for each entry. Is there a more smart way to do this? Thanks a lot in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smarter Idea
Look in HELP for the SUMIF() function
-- Kind regards, Niek Otten Microsoft MVP - Excel "Lp12" wrote in message ... | Hi All, | I have to check if there is data in B1:B3 (for example the entry '12') if | so, I need to add/sum the number that is written in the parallel cell in | A1:A3. | For example if in B1 = o,B2=12,B3=12 and in A1=1,A2=2,A3=3. then the total | (represent in cell C1) will be 5. I accomplished that by using IF sentence | for each entry. Is there a more smart way to do this? | Thanks a lot in advance | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Smarter Idea
it worked up gr8....
I can't believe i missed it... Thanks a lot y'all... "Niek Otten" wrote: Look in HELP for the SUMIF() function -- Kind regards, Niek Otten Microsoft MVP - Excel "Lp12" wrote in message ... | Hi All, | I have to check if there is data in B1:B3 (for example the entry '12') if | so, I need to add/sum the number that is written in the parallel cell in | A1:A3. | For example if in B1 = o,B2=12,B3=12 and in A1=1,A2=2,A3=3. then the total | (represent in cell C1) will be 5. I accomplished that by using IF sentence | for each entry. Is there a more smart way to do this? | Thanks a lot in advance | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!! No idea where to go next... | Excel Discussion (Misc queries) | |||
I've no idea how to do this. :( | Excel Worksheet Functions | |||
any idea? | Links and Linking in Excel | |||
any idea?? | Excel Worksheet Functions | |||
Help Please. No Idea what to look for or how to do this | Excel Discussion (Misc queries) |