Sum of data ranges in two different sheets giving two conditions

P

primi.gi

Hi All,
in two different ranges on two different sheets, I need to find data that
satisfy two conditions and SUM it in a cell of a third sheet.
The actual spreadsheet is related to accountancy: one sheet called Clients,
one called Invoices, one called Forecast, and so on.
In Forecast I put a simple db.sum that was just good enough (while in year
2008), but now we will keep inserting Invoice in the same sheet for year
2009, and I would like to have a sum for forcasted work for Client X in 2009.
Same for Invoices. Can someone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top