View Single Post
  #1   Report Post  
Farmer Mark
 
Posts: n/a
Default 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