SUM IF: How do I sum the data in a column based on 2 other columns
in [General]
|
From: jharoy on 19 May 2010 11:31 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.
From: sidm via OfficeKB.com on 19 May 2010 11:59 use a pivot table and use CoID and CoIE in the Row Field and CoIG person in the data field and summarize by count 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1
From: Abnerz on 19 May 2010 15:39 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.
|
Pages: 1 Prev: Count Dates & Return as % Next: Time difference across midnight |