I am looking for a formula that will sum/average all instances of data matching 3 specfic sets of criteria. I have attached a file containing what I am attempting to do (see cell comments). I think it requires some type of error checking as specific sets of data do not all contain full information. Any help would be greatly appreciated.
Last edited by bw26934; 07-15-2010 at 11:00 AM.
There seems to be only one of each match (Datatype,Date,Time)???
Anyway, if there are more than one match:
and
Please Login or Register to view this content.
in M2 and N2, respectively, and copied downPlease Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I only included one data type as the file would be quite large. There would be multiple matches but the formula above does not appear to be calcing all matches found, only returning the first value found.
The formulas above sum all the values in column E or F based on those 3 criteria matching.... is the criteria that the data type, date and type be exactly the same?
You will need to also expand the ranges to suit.
You are correct. I need to return a value that matches the data type, date and time (all 3). Function 1 needs to sum the matches and function 2 needs to average them.
I apologize for the confusion. I'm still a noob.
So is it still not working? Or did you get it?
not working yet. I don't understand what I need to do to get it working.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks