| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting data over multiple worksheets
Hi all,
I have run into the need to be able to count data over a large number of worksheets that all have an identical format (so cell D4 has the same type of data in it on every page). I want to be able to count the number of occurances that cell D4="Division" and N120.6 I currently use a combination of sumproduct, countif, and indirect, but I can't figure out how to get it to count based on multiple criteria. Thanks in advance for any help that you might be able to give. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| How do I link lots of data in multiple worksheets | Excel Worksheet Functions | |||
| counting rows across multiple worksheets | Excel Discussion (Misc queries) | |||
| Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
| Listing data from multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
