Logical Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me what is wrong with this function? I've switched from
Excel 2000 to 2003. - it used to work, but doesn't now.

=SUMPRODUCT(--(E6:E500=W24),(--(T6:T500="1")))

Trying to calculate how many have two existing conditions ALSO how many if
there are three existing conditions.
 
Are the values in T6:T500 text? If not remove the qoutations around 1 in your
criteria

Regards,

Peo Sjoblom
 
T is a number as text
E is an age developed by a formula
F is text
G is text
 
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

Nested IF Function problem for Excel 2003 7
If any cell in group matches any cell in another group 3
Conditional Calculations with Calculated Results 1
Count on Multiple Criteria over whole column 7
Sumproduct with three arrays 2
Problem with "IF" function 8
COUNT based on conditions in 2 or more columns 3
MULTIPLE (X3) COUNT IF FUNCTION 4

Back
Top