Hello,
I'm trying my hand at a SUMIFS formula with multiple criteria. I'm only looking to sum values in my sumrange that relate to a particular product. Sadly, my formula is returning 0 when it shouldn't.
Where $H$2 is my start date, $I$2 is my end date and my product name is in B11:
=SUMIFS(SUMRANGE,CRITERIARANGE1,"*"&B11&"*",Table[TableColumn2],And(>$H$2,<$I$2))
or maybe
=SUMIFS(SUMRANGE,CRITERIARANGE1,"*"&B11&"*",Table[TableColumn2],>$H$2,Table[TableColumn2],<$I$2)
The green portion of the formula returns a value when I rearrange it in a separate SUMIF formula. I can also do "=H2-I2", so my start and end dates are formatted correctly. TableColumn2 is also solely full of date values.
Can anyone tell me if I've formatted the red portion formula incorrectly? I'm not sure how to handle 2 different criteria within the same column, nor how to get the syntax of 'greater than' and 'less than' correct so as to imply a specified date range.
Thank you.
I'm trying my hand at a SUMIFS formula with multiple criteria. I'm only looking to sum values in my sumrange that relate to a particular product. Sadly, my formula is returning 0 when it shouldn't.
Where $H$2 is my start date, $I$2 is my end date and my product name is in B11:
=SUMIFS(SUMRANGE,CRITERIARANGE1,"*"&B11&"*",Table[TableColumn2],And(>$H$2,<$I$2))
or maybe
=SUMIFS(SUMRANGE,CRITERIARANGE1,"*"&B11&"*",Table[TableColumn2],>$H$2,Table[TableColumn2],<$I$2)
The green portion of the formula returns a value when I rearrange it in a separate SUMIF formula. I can also do "=H2-I2", so my start and end dates are formatted correctly. TableColumn2 is also solely full of date values.
Can anyone tell me if I've formatted the red portion formula incorrectly? I'm not sure how to handle 2 different criteria within the same column, nor how to get the syntax of 'greater than' and 'less than' correct so as to imply a specified date range.
Thank you.