Hello,
Looking for some help on a formula. I've attached a sample workbook. I'm trying to have a running total on column F once column G is completed with a ship date.
The formula I have right now is =IF(G2:G55<0,SUM(F2:F22),0)
but it's coming up w/zero. Any help would be great!
Thanks!
Last edited by beets; 09-14-2009 at 01:50 PM.
=sumif(g2:g5,">"&0,f2:f5)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
beets 
Register To Reply
Bookmarks