PDA

View Full Version : excel formaula



keilah
09-06-2007, 06:55 AM
Hi

is it possible to amend the following code so that as you drag the cursor across the columns the month decrease......from the current month

ie. AH3 = july07

=D69-SUMIF($B$6:$B$100,AH3,$A$6:$A$100)

thanks

keilah
09-06-2007, 07:17 AM
SOLVED IT USING EDATE