Excel 2007 : Sumifs help

**woods1110** · 04-26-2012, 12:07 PM

Hello all who can help!

I have a problem I have been struggling with for days. I have attached an excel file similar to what I am working with.

There are two worksheets: Summary and Data. On the summary worksheet, in cell B3, I am trying to count the # of Non Tech calls for Monday, January 02, 2012 from the Data worksheet.

I have tried to use a sumifs formula but it doesn't work because of the date headings on the data worksheet. I have no experience with offset formulas so I don't know where to begin.

Does this make sense and if so can anyone help?

Thanks in advance!

**daddylonglegs** · 04-26-2012, 12:14 PM

Try this formula in Summary B3 copied down

=INDEX(Data!B$4:B$120,MATCH(A3,Data!A$2:A$118,0))

**Cutter** · 04-26-2012, 12:17 PM

In B3 you can use:
=INDEX(Data!$B:$B,MATCH($A3,Data!$A:$A,0)+2)

In C3 you just change the 2 (at the end) to a 3

**woods1110** · 04-26-2012, 01:27 PM

Worked perfect! Thanks!

I looked at the formula to try to figure out how it worked and I guess I don't understand the INDEX and MATCH part of the formula. Any great websites out there that I can reference?

I consider myself pretty good with excel but I am in a position now where I need to expand my knowledge on formulas and getting help from you guys is great but I would like to learn the concept behind it.

Thanks again!