| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create non-contiguius range "IF"
Hi All.......
If someone would be so kind, I need help to create a non-contiguious range, based on a similar principal to SUMIF........instead of summing the values from the cells in column B adjacent to my selections in column A, I would like to assemble all of the individual cells in column B into a non-contiguious range and give it a RangeName. Sort of like.... =MAKERANGEIF(A:A,Choice,B:B) Any guidance would be much appreciated.......... TIA Vaya con Dios, Chuck, CABGx3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| How do I create a "SUMIF" based upon a Date Range? | Excel Worksheet Functions | |||
| Create pivot table, error "Range is not valid" | Charts and Charting in Excel | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Threaded Mode
