Perfect, thanks.
"JE McGimpsey" wrote:
If your data is sorted by date, that's what the formula I gave you
does...
If they're not sorted by date, a Pivot Table would probably be your best
choice.
In article ,
"RockyMountains" wrote:
Thankyou, I'm sorry I should have put in my question that I am looking for a
formula that gives me a running cumulative by owner by saledate total. Is
there a way to do that with the sumif?
"JE McGimpsey" wrote:
One way:
D2: =SUMIF($A$2:A2,A2,$C$2:C2)
Copy down as far as necessary.
|