sumifs - multiple conditions

[theath]

I would like to sum the values in table 1 column [Monthly Revenue] if the follwing conditions are met:

1. Table1[Type] = "Managed Service"

2. Table1[End Date] = current month and year recorded in cell BQ1


I am using this formula but having issues. It results in a zero, which is far from the correct amounth.


{=SUMIFS(Table1[Monthly Fixed Revenue],Table1[Type],"Managed Service",Table1[Contract End Date],TEXT(Table1[Contract End Date],"yyyymm")=TEXT($BQ$1,"yyyymm"))}

 

[Mike86]

Maybe something like this:


=SUMPRODUCT((Table1[Type]="Managed Service")*(text(Table1[Contract End Date],"yyyymm")=TEXT($BQ$1,"yyyymm"))*Table1[Monthly Revenue])

 

[theath]

works great! Thanks for the help!