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!
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!