SUMIF excel function not working

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

Guest

I am using this formula and it is returning a zero for the sum amount,
however, the function command tells me that it should return a 4 (which is
correct).

SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352="60"),F2:F3352))

What am I doing wrong?
 
If Column G contains numerical values, remove the quotes from its
criterion...

=SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352=60),F2:F3352))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
Worked great, Thank You.

Domenic said:
If Column G contains numerical values, remove the quotes from its
criterion...

=SUM(IF((A2:A3352="Bee, Lucas W.")*(G2:G3352=60),F2:F3352))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
Click to expand...
 
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

Sumif on columns with logical answers 1
WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT 4
SUMIF OR SUMPRODUCT?? 3
SUMIF 2
Sumif Function 2
Combining SUMIF and SUBTOTAL 4
How can I define date range criteria in SUMIF formula? 1
IF AND Nested Functions - Formula Not Working 0

Back
Top