- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Excel Conditional Sum

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

- RE: Excel Conditional Sum posted by Ron Coderre on Mon, 1 May 2006