From: jharoy on
It worked, Thank You Very much!
"Abnerz" wrote:

> try sumproduct
> --
> Abner
>
>
> "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.