| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Identify missing criteria
I am an experienced excel user, but stuck in the same basic functions.
I am trying to move my skills to the next level, and am currently building a model which uses the sumif function to summarize data from a linked access table. Unfortunately, the total of the sumif items does not equal the total of the raw data, which leads me to believe there are criteria items in the source data which I do not have in my sumif table. Is there an easy method to identify the missing criteria? Thanks for the assistance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| Identify missing record numbers | Excel Discussion (Misc queries) | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
| SUMIF with more than 1 criteria | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
