I am using below formula to calculate SUM of column V when A column Year matches to 2021 and A column month matches to January (1)

=SUMIFS('Trade Log'!V:V,YEAR('Trade Log'!A:A),"2021",MONTH('Trade Log'!A:A),"1")

But this giving me below error

Error
Array arguments to SUMIFS are of different size.

Unable to figure out the issue here. Any guidance please

Sample Google sheet

CodePudding user response：

Try

=SUMPRODUCT(YEAR(A:A) = 2021, MONTH(A:A) = 1, V:V)

and see if that helps?

CodePudding user response：

try:

=INDEX(SUMIFS('Trade Log'!V:V,
 YEAR('Trade Log'!A:A), "2021",
 MONTH('Trade Log'!A:A), "1"))