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 |
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) |