From: jharoy on 20 May 2010 10:41
It worked, Thank You Very much!
> try sumproduct
> "jharoy" wrote:
> > Can someone help me? I would like to know how to total the # of persons who
> > have "Scheduled Appointments" and need "Housing Assistance. I am extracting
> > this data from a separate spreadsheet in the same work book titled "May" &
> > would like it to appear on my Calculation SS.
> > ColD ColE ColG
> > Housing Assistance Scheduled Appt # Person
> > This is How my Calculation SS appears:
> > Col A ColB ColC
> > Scheduled Appt Housing Assistance # Person
> > I know this is alot of info but I want to be specific. I appreciate any help.