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

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

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

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