| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing specific cells on two worksheets
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(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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automate selection of specific reference cells | Excel Discussion (Misc queries) | |||
| adding specific cells | Excel Worksheet Functions | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Referencing cells in different worksheets | Excel Worksheet Functions | |||
| how to delete contents of cells having specific data | Excel Discussion (Misc queries) | |||
Threaded Mode
