Hi All,
I need to sum up some data from two ranges (on to different sheets) when
data meets two conditions.
It's an accountancy spreadsheet and I have one sheet for Clients, one for
Invoices, one for Forecast, and so on. In a cell of a different sheet I would
need to sum all Invoices (total money) of a Client (first condition) when
year = 2009 (second condition). I created the file in 2008 and had only a
DB.SUM for the whole year that was working just fine, but now we will carry
on inserting data in the same sheets for 2009 as well....
Can anybody help?