Using SUMIF To sum cells meeting multiple criterion from another column

[osa]

Hi all, thanks in advance for any help.

I have a very large spreadsheet. On one worksheet, I have the all the data, and on a second worksheet I have tables calculating statistics from the first worksheet.

I am trying to calculate a certain stat. it is

- the sum of all profit (column G in worksheet 1)
- when the instrument prefix (column H in worksheet 1) is ZB (or whatever the value is in column C in the second spreadsheet)
- and the account is (column C in worksheet 1) is DmiMA2 (or whatever the value is in column B in the second spreadsheet, which I realize is labeled 'strategy')
- and the week beginning (column I in worksheet 1) is 7/7/13 (or whatever the column A in the second spreadsheet)

I believe this can be done by SUMIF, but I'm not sure how to express that complex set of condition. It also feels somewhat like a LOOKUP function, since I am asking excel to lookup a value and add those values together).

I've attached a spreadsheet, if it'll help

[FDibbins]

you are almost there, take a look at sumifS() intead

[osa]

Thanks a million. That's what I was looking for. I'm on my way

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)