Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum of data ranges in two different sheets giving two conditions
If there ONE condition for each worksheet:
=SUMIF(Sheet1!range_one,criteria_one) + SUMIF(Sheet2!range_two,criteria_two) If there are TWO criteria for each sheet =SUMPRODUCT(etc) + SUMPRODUCT(etc) If required, please ask for more details on SUMPRODUCT after reading: Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "primi.gi" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum of data ranges in two different sheets giving two conditio
-- Many thnks, that solved the issue. :) Primigi "Bernard Liengme" wrote: If there ONE condition for each worksheet: =SUMIF(Sheet1!range_one,criteria_one) + SUMIF(Sheet2!range_two,criteria_two) If there are TWO criteria for each sheet =SUMPRODUCT(etc) + SUMPRODUCT(etc) If required, please ask for more details on SUMPRODUCT after reading: Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "primi.gi" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One Chart, Same Data ranges, different source sheets | Charts and Charting in Excel | |||
time sheets giving a minus | Excel Discussion (Misc queries) | |||
in charting, how do i select data ranges from multiple sheets, sa. | Charts and Charting in Excel | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Protect Sheet but enable cell ranges giving Error 1004 Unable to set | Excel Programming |