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)
=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??/
=SUM((MONTH(Indirect($C24:$C30))=MONTH(3))*Indirect(D24:I30))
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.