Formula - SUMIF - Can any help?

[Tower1]

Hi,

I am in the process of doing up an excel spreadsheet where I need to calculate a dollar figure of all my converted functions per month. So I need to do a sum if which looks like this:

Range: Which is the column of the Month of the enquiry (this column has all option to select which ever month the enquiry came through)
Criteria: Which is the month that I am calculating ie. July
Sum Range: The dollar figure column ie Total Food and Beverage spend

This formula calculates the total dollar figure of an enquiry per month.

Now I need 1 more selection criteria which is for the column which I use to say that I have converted a function. Which should only give me a dollar figure of the events that I have converted that month.

Can anyone tell me how to get a 4th criteria so I can calculate this?

Any help would be much appreciated.

Thanks,
Kim

 

[AlphaFrog]

If you have Excel 2007 or later, you can use the SUMIFS function.

If you have Excel 2003 or earlier, use the SUMPRODUCT function.

 

[Tower1]

Thank you - very helpful and successful. Just what I was after.

Kim