Formula that considers two criteria

[tbrynard01]

I have a sheet that has a date column and a category and would like to add the totals for all the lines with the same category within a specified date range together. I'm using this below, but it's including items outside of this date range

IF(AND('Check Register-Sep2017'!C:C,9/1/17,9/30/17),SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red"),0)

Can anyone please help?

Thanks

 

[mc5476]

Within the nested AND statement, you have to phrase the conditions as equations. This is different than the SUMIMF syntax.
Try this:
=IF(AND('Check Register-Sep2017'!C1>9/1/17,'Check Register-Sep2017'!C1<9/30/17),SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red"),0)

 

[bosco_yip]

Maybe,

=IF(AND('Check Register-Sep2017'!C1>=0+"9/1/17",'Check Register-Sep2017'!C1<=0+"9/30/17"),SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red"),0)

Regards

 

[tbrynard01]

Maybe,

=IF(AND('Check Register-Sep2017'!C1>=0+"9/1/17",'Check Register-Sep2017'!C1<=0+"9/30/17"),SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red"),0)

Regards

Thank you I tried both suggestions but neither worked

 

[Aladin Akyurek]

I have a sheet that has a date column and a category and would like to add the totals for all the lines with the same category within a specified date range together. I'm using this below, but it's including items outside of this date range

IF(AND('Check Register-Sep2017'!C:C,9/1/17,9/30/17),SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red"),0)

Can anyone please help?

Thanks

Try:

=SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red",'Check Register-Sep2017'!C:C,">=9/1/17",'Check Register-Sep2017'!C:C,"<=9/30/17")

 

[tbrynard01]

Try:

=SUMIFS('Check Register-Sep2017'!H:H,'Check Register-Sep2017'!F:F,"Red",'Check Register-Sep2017'!C:C,">=9/1/17",'Check Register-Sep2017'!C:C,"<=9/30/17")

Thank you! This worked.

 

[Aladin Akyurek]

Thank you! This worked.

You are welcome.