| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Totalling Criteria from Muliple Worksheets
I have monthly worksheets that use drop down boxes to pick criteria from
lists. The linked cell outputs a number based on what the chosen criteria was in the drop down box. Currently I use this outputted number on a summary sheet with a COUNTIF formula ie COUNTIF(Sept!$R$3:$R$200,2) to summarize monthly info. I would like to generate yearly info instead without having to generate monthly totals first. Is there a formula that can use both ranges - Jan:Dec and $R$3:$R$200 - with the criteria of the linked cell ie. 2? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfering and totalling corresponding data to other worksheets | Excel Discussion (Misc queries) | |||
| sorting more than 3 keys | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| Totalling Separate Worksheets | Excel Worksheet Functions | |||
Threaded Mode
