Excel 2007 : Sum with Names and Dates

**keith6292** · 08-07-2011, 01:02 PM

Column A contains "Names" and Row 1 contains "Dates" from now until Jan. Under each date will be a number value corresponding with a persons name. I need a formula that will lookup a specific name from column A and Sum the values for each month. ex. Cell A2(keith) Rows B1 (July 2) - G1 (Sept 4) I need to know how many numbers were inputed for Keith during the month of july. Could someone please help with this?

Thanks

Keith

**protonLeah** · 08-07-2011, 01:11 PM

Please look up SUMIF & COUNTIF or post a sample workbook with enough data to write formulas

**Haseeb Avarakkan** · 08-07-2011, 01:15 PM

Hello Keith,

Consider Sheet1 has the data.

In Sheet2,

A1 = Keith
A2 = 7/1/2011

A2 is the Start Date of the month, then

=SUMIFS(INDEX(Sheet1!1:65536,MATCH(A1,Sheet1!A:A,0),0),Sheet1!1:1,">="&A2,Sheet1!1:1,"<="&EOMONTH(A2,0))

**keith6292** · 08-07-2011, 01:24 PM

On employee list sheet is where I need the formula entered.

Thanks

Keith

**keith6292** · 08-07-2011, 01:45 PM

this is returning #NA. i posted an example. are you able to look at it for me?

Thanks

**Haseeb Avarakkan** · 08-07-2011, 01:54 PM

In Employee List D4, copy down & across.

=SUMIFS(INDEX('BBO Count'!$1:$1048576,MATCH($B4,'BBO Count'!$B:$B,0),0),'BBO Count'!$1:$1,">="&D$3,'BBO Count'!$1:$1,"<="&EOMONTH(D$3,0))