How would i modify the following code to used a cell that Has the number 3 for the month of March vs Today()
[vba]
=SUM((MONTH($C24:$C30)=MONTH(TODAY()))*D24:I30)
[/vba]
How would i modify the following code to used a cell that Has the number 3 for the month of March vs Today()
[vba]
=SUM((MONTH($C24:$C30)=MONTH(TODAY()))*D24:I30)
[/vba]
[VBA]=SUM((MONTH($C24:$C30)=MONTH(3))*D24:I30)[/VBA]
Ok that worked perfectly...but heres another can of worms...
If i was to delete B22:J32 and Shift Cells up the Formula above cleares out and puts #REF How can i keep the Formula intacted?? basically dont touch AD22:AR22 Keep them intacted??/
[VBA]=SUM((MONTH(Indirect($C24:$C30))=MONTH(3))*Indirect(D24:I30))[/VBA]