SUMPRODUCT formula challenge

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

Guest

I have 3 columns in excel one contains words, one contains letters and one
contains numbers. I want to add the numbers when the word in column one and
the letter in column two are to values I've set.

I'm using the following formula, but keep getting a syntax error:
=SUMPRODUCT(--($J$33:$J$51="Core");--($M$33:$M$51="M");$L$33:$L$51)
 
Check your list separator! In English You should use commas instead of
semicolomns! Otherwise the formula is correct.

Regards,
Stefi


„Mitchell†ezt írta:
 
Thanks, that worked perfectly.

Stefi said:
Check your list separator! In English You should use commas instead of
semicolomns! Otherwise the formula is correct.

Regards,
Stefi


„Mitchell†ezt írta:
Click to expand...
 

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

Scrabble Value calculation for Welsh words 0
Sumproduct - Second Attempt 4
Formula (or code) return the largest number of duplicates in a list. 16
Sumproduct 1
SUMPRODUCT: dividing the formula of one cell by another. 1
Average Value 34
Is this formula possible in Excel 2003? 1
calculating average handling time 7

Back
Top