Assigning a named cell in the Cond Sum If

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a column named 'Month' and a cell named
SelectMonth. I am trying to use SelectMonth so that I can
sum a column named 'Gross' by 'Month' by 'Model' by 'Adj'
Each has a validation data list assigned to it. My
statement will not recognize the cell 'SelectMonth' and
gives me a null result. Help
 
Hi
try
=SUMPRODUCT((Month_rng = SelectMonth)*(Model_rng = Adj),Gross_rng)

Note:
- all ranges (Month_rng, Model_rng and Gross_rng) must have the same
dimension
- you can't use a range like A:A, use something like A1:A10000
- also I wouldn't use a range name like 'Month' as this is identical to
a function name
 
You must log in or register to reply here.

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

sumproduct problem 4
Using a conditional sumif which allows a cell name as one of the criteria 1
use month in cell date to sum all relevant cells 2
Assigning a Worksheet Name to a Cell 4
How can I assign a value to a cell without putting a formula in it 4
Sums including #NAME? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Sum if two conditions met 3

Back
Top