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 |
#2
|
|||
|
|||
If you have access you could write a query looking for distinct entries in you criteria field or you bring the database into excel and use advanced filters to display the unique entries. Lanceb "Farmer Mark" wrote: 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 |
#3
|
|||
|
|||
This formula will tell you how many unique items there are
=SUMPRODUCT((A1:A50<"")/COUNTIF(A1:A50,A1:A50&"")) -- HTH RP (remove nothere from the email address if mailing direct) "LanceB" wrote in message ... If you have access you could write a query looking for distinct entries in you criteria field or you bring the database into excel and use advanced filters to display the unique entries. Lanceb "Farmer Mark" wrote: 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 |
#4
|
|||
|
|||
Hi
i would use data / pivot table and pivot chart report to create a pivot table out of the access data, this will enable you to easily check what you've missed etc. Cheers JulieD "Farmer Mark" wrote in message om... 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 |
Reply |
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 |