Sorting information

[CraigMacE]

I'm looking for a way to replace a SUMIFS formula to make a worksheet
compatible with older versions of excel. I have a worksheet for data entry 6
columns wide with categories such as names, dates and a number. My SUMIFS
adds up all the numbers with a specific name and date.

My thought was some to use some sort of function to sort out all of the
information by date and put it in its own separate list.

 

[Max]

Don't have xl07, but do recollect some reading
that the new SUMIFs is akin to multi-criteria SUMPRODUCT,
indicatively: SUMPRODUCT((Cond1)*(Cond2),SumRange)

The other relevant point is that sumproduct ranges
for use in versions before xl07 cannot be entire col ranges
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik