SumProduct or VLookup

I am trying to create a formula that will check multiple criteria on another tab within the sheet and if it is a match then the sum will be shown. If no match then no sum will be shown. I have tried to do it using SumProduct but just cannot get my head around it? If it can be worked out then I can use the formula to populate all of the other cells on the page.

My page has a few columns as follows:

Acc. #: I need to check if the string ST is anywhere. So the cell may contain ST52 but I only care if it is ST
Date: In my example I need to check to see if the month if February and the year is 2015
Description: Just needs to check for the string Staff One Salary

If the above 3 conditions are met then the relevant cells in column I need to be added up

I have attached an example spreadsheet with the relevant cells highlighted in red and hope it makes sense

Hi, Margate!

You can use this formula:
[J8] : =SUMIFS(Accounts!$I:I,Accounts!$D:$D,"ST*",Accounts!$E:$E,">="&1&J7&2015,Accounts!$E:$E,"<="&EOMONTH(1&J7&2015,0),Accounts!$F:$F,"Staff One Salary")

Blessings!

Wow, no wonder I could not work it out, I was thinking about Index Match and never thought it possible with SUMIFS. Even if I did think about SUMIFS I was way out of my depth. Thank you very much, this has helped me a lot. I will mark this thread as solved.

Regards,

Margate.