This was originally posted under Worksheet functions forum, i deleted it there and moved it to this forum. No cross-forum posting occured. Thanks
This is part of a routine.
I want to do an average for a certain range. Application.Average will not work in this case.
I have a named range (f) in col c that looks up a value in the range and do some calulations based on conditions on subseqeunt cols.
The sumif part works fine but when i use columns() in sumproduct() it results in an error.
Any help appreciated
Attached is an example of how how the formula should work. but i can't get it to do so.
Thanks
Bookmarks