In Sort Options enable "my data range has header row"


Gord

On Sun, 10 Jun 2012 15:48:57 +0000, dkte737
wrote:


Spencer101;1602557 Wrote:
I've used SUMPRODUCT in the attached. It can also be done with SUMIFS
but it's far less easy to read.

Hope it makes sense. Feel free to clarify if not.

That worked! Ok, simple question....how did you get your top row (DATE)
to not move when you sort oldest to newest?

David


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+