I am using code to check a cell value and then sum across worksheets if the cell value checked matches a key word. I have been getting by with the following code: (note my sheets are named sequentially from 1 to 21 and the word to be checked matched is in cell F45)

=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!$F$45"),"Condition1",INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!D"&ROWS($A$2:$A3))))
I wish to add 1 additional criteria (second word to be matched is in cell K45)

I have tried code such as:

=SUMPRODUCT(SUMIFS(INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!$F$45"),"Condition1",INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!$K$45"),"Condition2",INDIRECT("'"&ROW(INDIRECT("1:21"))&"'!D"&ROWS($A$2:$A3))))
As you can probably tell I have no experience whatsoever with the SUMIFS command and my syntax is probably all messed up :/

Could somebody please correct my mistakes?

Regards and much thanks,

Michael.