sumproduct and sumifs using multiple criteria across worksheets

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)

Please Login or Register  to view this content.

I wish to add 1 additional criteria (second word to be matched is in cell K45)

I have tried code such as:

Please Login or Register  to view this content.

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.

Thank you for the reply.

The code is accepted but it fails to display any result even when I set up some sheets to match the tested criteria...

Is there anything else I might try?

I stand corrected

The code works, I made simple example which I attached

The problem was I had lined up the rows wrong

Please Login or Register  to view this content.

In the above example my numbers would have been in row 3 (column D) where as this section works when the numbers are in row 2 (column D).

I must admit I don't fully understand how the code works, we specify Column D and then use the letter A when entering the range, obviously column A is blank. Furthermore we specify a range that extends 1row below where my data is.

All that aside the code works brilliantly and I thank you for your assistance