use month in cell date to sum all relevant cells


Chris Smith

Hi - I have a Sheet of orders entered in rows, order date is col D and order quantities in columns O through AM (1 product per column, if not required cell is blank). On a different sheet I am trying to sum all the orders for each product / month

I have entered
meaning if the month value in the cell is 4 (April) count any quantity in corresponding cell column O.

What have I done wrong please?

Thanks for looking

Claus Busch

Hi Chris,

Am Tue, 16 Jul 2013 13:09:22 -0700 (PDT) schrieb Chris Smith:

and enter the array formula with CTRL+Shift+Enter

Claus B.

Chris Smith

Thank you Claus

I should have thought of SUMPRODUCT - It is extremely useful and better than an array I think.


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