Mudcat Café message #2935880

The Mudcat Café ^TM
Thread #130345 Message #2935880
Posted By: Bonzo3legs
28-Jun-10 - 05:38 AM
Thread Name: BS: A well balanced fair budget! (UK)
Subject: RE: BS: A well balanced fair budget!

SUMIF($F$3:INDEX($F:$F,ROW()-1),"Closing Balance:",G$3:INDEX(G:G,ROW()-1))+SUMPRODUCT(--($F$2:$F$11766="Opening Balance:"),--($F$3:$F$11767=""),G2:G11766)

..a formula I devised recently!!!!!