Vary range in sumif formula

Hi,

How can I change the range that is summed in a sumifs formula based on the entry in another cell. For example, if a user selected Prod A in cell A1, the sumifs would sum column M. If product B was selected, the sumifs would sum column N. If product C was selected it would sum column Q.

I know I can do this using a lot of 'if' statements but there are too many products for this to be done realistically. The first part of the sumifs formula is the same for all, I just need to change the range summed.

Thanks in advance for any help.

If you have a table somewhere which lists the products in one column and the column letter(s) where the data can be found in the next column, then you can use a VLOOKUP function to return the appropriate letter(s), and then you can make use of INDIRECT to give you the appropriate range for your SUMIFS function.

Hope this helps.

Pete

Ah yes, that makes sense and is relatively straightforward. Many thanks!