ExcelBanter - SUMIF with 3 criteria vs 2 criteria

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

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

- - SUMIF with 3 criteria vs 2 criteria (https://www.excelbanter.com/excel-worksheet-functions/176508-re-sumif-3-criteria-vs-2-criteria.html)

Teethless mama

SUMIF with 3 criteria vs 2 criteria

Try like this:

{=SUM(IF($H$9:$H$116={1,4},IF(LEFT($J$9:$J$116)="y ",$I$9:$I$116)))}

"jane" wrote:

this works:
{=SUM(IF($H$9:$H$116=4,IF(LEFT($J$9:$J$116)="y",$I $9:$I$116))))}

but this does not:
{=SUM(IF($H$9:$H$116=4,IF($H$9:$H$116=1,IF(LEFT($J $9:$J$116)="y",$I$9:$I$116))))}
need to know if col H contains a 1 or a 4 and J starts with a y - my result
is 0 but should be 2130

suggestions??? thanks in advance!, jane

Jane

SUMIF with 3 criteria vs 2 criteria

this also worked perfectly
thank you!

"Teethless mama" wrote:

Try like this:

{=SUM(IF($H$9:$H$116={1,4},IF(LEFT($J$9:$J$116)="y ",$I$9:$I$116)))}

"jane" wrote:

this works:
{=SUM(IF($H$9:$H$116=4,IF(LEFT($J$9:$J$116)="y",$I $9:$I$116))))}

but this does not:
{=SUM(IF($H$9:$H$116=4,IF($H$9:$H$116=1,IF(LEFT($J $9:$J$116)="y",$I$9:$I$116))))}
need to know if col H contains a 1 or a 4 and J starts with a y - my result
is 0 but should be 2130

suggestions??? thanks in advance!, jane

All times are GMT +1. The time now is 06:44 AM.