Summing specific cells on two worksheets

[srpettew]

Hi,

I'm working with a license purchase history and have multiple tabs
representing each year with one tab being a "summary" of the total number of
purchased licenses. I have already hand counted the total of all worksheets
and entered the numbers manually on the summary sheet. Going forth, I would
like the summary sheet to update automatically whenever a license is added to
the current year tab. So, for example, if the total number of licenses on
the summary worksheet for a particular product is 7, and I add 2 more to the
current year worksheet, the summary should now show 9 as the total. This
seems simple but I'm having a hard time with the formula. Here's what I use
but it will not work.
Choose the cell on the summary sheet and type the following:
=SUM('Summary!B2,'LicensePurchase7!N2) Where N2 is the total for the
specific year. I've also tried different variations of this but cannot get
it to work.

Any help is appreciated!
Thanks,
SP

[stvgarner]

Will the countif function work? Say on the summary sheet you have the product in cell a1, then you could count the matching products in each years sheets to get the total.


=countif(Year1Sheet!A:A,Summary!a1)+countif(Year2Sheet!A:A,Summary!a1)


Where the product is in the A column of the YearSheets.

[srpettew]

I will try this. Thanks for the tip.

SP

"stvgarner" wrote:

>
> Will the countif function work? Say on the summary sheet you have the
> product in cell a1, then you could count the matching products in each
> years sheets to get the total.
>
>
> =countif(Year1Sheet!A:A,Summary!a1)+countif(Year2Sheet!A:A,Summary!a1)
>
>
> Where the product is in the A column of the YearSheets.
>
>
> --
> stvgarner
> ------------------------------------------------------------------------
> stvgarner's Profile: http://www.excelforum.com/member.php...o&userid=20599
> View this thread: http://www.excelforum.com/showthread...hreadid=534699
>
>