UDF for Sumproduct

Q

QuietMan

I'm trying to create a UDF for sumproduct that will be dynamic on the numbers
of criteria (3 to 5), uses a defined range and offsets from that rage to get
the criteria ranges and sumrange.

Example:
The defined range is always in column A and automatically set for row 1 to
the last row of data

The function would offset from this range based on there criteria (column2
contains first criteria, column 8 contains second criteria...etc)

Before I dove off inot the deep end I was hoping that some one would be able
to help get me started on the best possible way to do thsi

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top