The reason I have the "" in the IF statement is because I don't want the
entire worksheet filled with "0". If there is no data for say the month
of July cause it has not reached July, I don't want the cells to read
"0", I want them to read nothing at all, for neatness and clarity when
using and printing the spreadsheet.
Is there a way I can keep that sum array formula and omit certain cells
from being added?
For example:
{=SUM((Lantigua!$C$2:$HJ$2=DATEVALUE("1-Jan"))*(Lantigua!$C$2:$HJ$2<=DATEVALUE("31-Jan"))*(Lantigua!$C$5:$HJ$5))}
Omitting cells
J5,R5,Z5,AH5,AP5,AX5,BF5,BN5,BV5,CD5,CL5,CT5,DB5,D J5,DR5,DZ5,EH5,EP5,EX5,FF5,FN5,FV5,GD5,GL5,GT5,HB5 ,HJ5
These are the cells that contain the IF statement, I figure if I can
omit those cells from being summed up, the array formula will work
fine.
--
malik641
------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread:
http://www.excelforum.com/showthread...hreadid=378044