Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Array Formula
I am endeavouring to sum an amount column in a XP Pro spreadsheet based on
various criteria such as Client ID Number, Product ID, DateRange etc with the result passed to a variable. I am assuming that a VBA produced array formula is the best approach. I am comfortable with just the above criteria but one final condition has me stumped That is, in additional condition to the above is that I only want to include cells in the amount column that have an interior.colorindex applied. In other words Interior.colorindex < xlNone. All attempts so far, to apply the color condition to various formats of the amount range have resulted in various error messages. Can anyone save my sanity on this one TIA John Howard Sydney, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Array Formula
Hi
as a starting point: http://www.xldynamic.com/source/xld.ColourCounter.html "SMS - John Howard" wrote: I am endeavouring to sum an amount column in a XP Pro spreadsheet based on various criteria such as Client ID Number, Product ID, DateRange etc with the result passed to a variable. I am assuming that a VBA produced array formula is the best approach. I am comfortable with just the above criteria but one final condition has me stumped That is, in additional condition to the above is that I only want to include cells in the amount column that have an interior.colorindex applied. In other words Interior.colorindex < xlNone. All attempts so far, to apply the color condition to various formats of the amount range have resulted in various error messages. Can anyone save my sanity on this one TIA John Howard Sydney, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Array Formula
To Frank Kable
Thanks for your response and URL site. Your response bypassed this forum and came to me by direct email from some intrusive mob called Developersdex. Regards JH "SMS - John Howard" wrote in message ... I am endeavouring to sum an amount column in a XP Pro spreadsheet based on various criteria such as Client ID Number, Product ID, DateRange etc with the result passed to a variable. I am assuming that a VBA produced array formula is the best approach. I am comfortable with just the above criteria but one final condition has me stumped That is, in additional condition to the above is that I only want to include cells in the amount column that have an interior.colorindex applied. In other words Interior.colorindex < xlNone. All attempts so far, to apply the color condition to various formats of the amount range have resulted in various error messages. Can anyone save my sanity on this one TIA John Howard Sydney, Australia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Array Formula
Hi John
no idea why this happened. I see you're using OE for posting directly to this NG. Maybe just someone who scans the NG regulary? -- Regards Frank Kabel Frankfurt, Germany SMS - John Howard wrote: To Frank Kable Thanks for your response and URL site. Your response bypassed this forum and came to me by direct email from some intrusive mob called Developersdex. Regards JH "SMS - John Howard" wrote in message ... I am endeavouring to sum an amount column in a XP Pro spreadsheet based on various criteria such as Client ID Number, Product ID, DateRange etc with the result passed to a variable. I am assuming that a VBA produced array formula is the best approach. I am comfortable with just the above criteria but one final condition has me stumped That is, in additional condition to the above is that I only want to include cells in the amount column that have an interior.colorindex applied. In other words Interior.colorindex < xlNone. All attempts so far, to apply the color condition to various formats of the amount range have resulted in various error messages. Can anyone save my sanity on this one TIA John Howard Sydney, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions |