ExcelBanter - SUMIF excel function not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF excel function not working (https://www.excelbanter.com/excel-worksheet-functions/44724-sumif-excel-function-not-working.html)

AMXAH

SUMIF excel function not working

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?

Domenic

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!

In article ,
"AMXAH" wrote:

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?

AMXAH

Worked great, Thank You.

"Domenic" wrote:

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!

In article ,
"AMXAH" wrote:

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?

All times are GMT +1. The time now is 07:29 AM.