| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create an "if then" formula
I have 6 worksheets which I would like to copy the data into a "summary"
worksheet. I would like to make this as simple as possible, so how can I copy or create a formula in the "summary" worksheet that will check the legend in column "a" and return the value with that value that in column "b" if the "summary" worksheet column "a" does not have a value in the previous 6 worksheets return the value of "0". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Threaded Mode
