Training Completions by Month and Current Year

[francoiscj1]

This is my formula and it has an error that I'm having difficulty finding:

=sumproduct(($F13:$F50>=Date(year(today()),1,1))*($h13:$H50>=Date(Year(Today()),1,1))*($G13:$G50<=Date(year(today()),1,31))*($I13:$I50="Compliant"))

Thank you for the help.

 

[awoohaw]

Are you getting an error message or are you getting a value you know is wrong? Can you provide some examples and expected values? And any error messages? You can use the xl2bb add in (link below) or post the data as a copyable table (please do not merely post an image.) THanks in advance.

 

[awoohaw]

Well, i got a formula to calculate by adding more parentheses. Not sure if I added too many, but this seems to work:

=SUMPRODUCT(
(($F$13:$F$50)>=DATE(YEAR(TODAY()),1,1))*
(($G$13:$G$50)>=DATE(YEAR(TODAY()),1,1))*
(($H$13:$H$50)<=DATE(YEAR(TODAY()),12,1))*
(($I$13:$I$50)="Compliant")
)

PS: Please update your profile with what version of excel you use. It didn't really matter for this question, but some functions are not available in earlier versions of excel. (see how my profile button shows "365" for office version?)

 

[francoiscj1]

Thank you awoohaw -- it works!

 

[awoohaw]

My pleasure, best wishes.