Resulting value based on multiple criteria using formulas

Hello

I want to put together a spreadsheet for tracking budget spend, that allows me to get specific values displayed in selected cells on the required tab. I want these values to be displayed dependent upon a pre-defined criteria.

For example, the spreadsheet I have uploaded has two tabs. One tab shows the overview where I want to display this selected information and another tab called "PO" which contains the details of all my purchase orders.

In the "Overview" tab, cell D4 shows the values from the other tab "PO" depending on if column C says 'Design/Print' and then gives the total of the corresponding value from column F which is £8000.

This is only a part of the criteria I want to set.
I want to only show the total value in "Overview" tab, cell D4 when on tab "PO", column L gives the value of "P1", so the total value should actually be £6000.

Does anybody know how to achieve this?

I tried =SUMIF(PO!$C$10:$C$43,"Design/Print",PO!$F$10:$F$43, PO!$L$10:$L$43,"P1")
and I got an error message advising that I have entered too many arguements.

Any help would be very much appreciated.
Thanks

Debbie :O)

P.S. I forgot to say that I am editing this spreadsheet tonight using Excel 2007, but I normally run it on Excel 2000. Thanks :O)

You can use this in cell D4

Please Login or Register  to view this content.

EDIT - for clarification your SUMIF() didn't work because it is limited to only one criteria but you have two.
In 2007 and later there is a SUMIFS() function that would do what you want but since you need this for Excel 2000 you can't use it.