View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
primi.gi primi.gi is offline
external usenet poster
 
Posts: 2
Default Sum of data ranges in two different sheets giving two conditions

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?