Vlookup/sumproduct scan date and sumproduct adjecent cells

[charliew]

Hi,

I'm relatively new to excel so bare with me.

I'm trying to search a column for a specific date and then sumproduct in an adjacent cell...

this is what I've managed:

=SUMPRODUCT((O$2:O$963=ED)*(F$2:F$963=W69))

this doesn't work!

I have date ranges with times for completed reports (f) so sometimes 4 or 5 of the same dates with different times, and "ED" in some of the adjacent cells (o). I am trying to add up how many times ED is used for a each day...
I have a separate column with every date of the year in (for a different formula) (w) that I want to place this next to

Thank you for help in anticipation!

 

[AhoyNC]

What formula are you using?

You may also want to look at the AVERAGEIF function to exclude 0's from your average.

Excel Workbook
	A	B	C
1	1
2	5		7.286
3	6
4	8
5	12
6	0
7	14
8	5
Sheet