View Single Post
  #6   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.