Excel Conditional Sum

Giganews Newsgroups
Subject: Excel Conditional Sum
Posted by:  Andy
Date: Mon, 1 May 2006

To Whom it may concern:

I am working with data that I learned in the Nursing Reportiing webcast last
week.

When I create the table & go to copy the formula & up the month by one the
data does not update. Below are the codes one copied & one created when using
the conditional sum wizard:

=SUM(IF('PNB Raw'!$A$2:$A$253="PN3b",IF('PNB Raw'!$C$2:$C$253=4,IF('PNB
Raw'!$D$2:$D$253=2005,'PNB Raw'!$H$2:$H$253,0),0),0))
=SUM(IF('PNB Raw'!$A$2:$A$253="PN3b",IF('PNB Raw'!$C$2:$C$253=4,IF('PNB
Raw'!$D$2:$D$253=2005,'PNB Raw'!$H$2:$H$253,0),0),0))

Any thoughts why the data doesn't update & only returns the value of 0?

--
Thanks,
Andy

Replies