Thread: Summing specific cells on two worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
stvgarner
 
Posts: n/a
Default Summing specific cells on two worksheets

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(Year2S heet!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

Reply With QuoteReply With Quote