PDA

View Full Version : Question on Formula



menor59
03-13-2013, 11:55 AM
How would i modify the following code to used a cell that Has the number 3 for the month of March vs Today()

=SUM((MONTH($C24:$C30)=MONTH(TODAY()))*D24:I30)

SamT
03-13-2013, 12:14 PM
=SUM((MONTH($C24:$C30)=MONTH(3))*D24:I30)

menor59
03-13-2013, 12:36 PM
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??/

SamT
03-13-2013, 02:02 PM
=SUM((MONTH(Indirect($C24:$C30))=MONTH(3))*Indirect(D24:I30))