SUMIF Based on Dates

[DJ'sGiGi]

I need help with a SUMIF based on dates formula. I've compared my formula to another one the forum where the user was attempting to do exactly the same thing I'm trying to do. I have a column with dates and one with % of the day worked. I need to sum the time for cells with the same date to make sure the person has not worked more than 1.0 day on any given date. Columns A-C of the data and the formula I'm using look like this:

<PRE>
9/16/2014 OFF 0.00 "=SUMIF($A$6:$A$18,A6,$B$6:$B$18)"
9/17/2014 0.50 0.50
9/17/2014 0.75 0.75
9/18/2014 0.25 0.25
9/18/2014 0.00
0.00
0.00


</PRE>

As you can see, Excel is not totaling correctly because I should have 1.25 for 9/14/2014.

Your help and suggestions are appreciated.

 

[Sahak]

Your formula Works perfect, it gives 1.25 for date 09/17/14

 

[DJ'sGiGi]

Geez Louis!! It's totally not working for me. The results in the post are the one's I'm getting. Did you lay your data out exactly like in my post?

 

[Sahak]

Yes, exactly like your's. Look for formats in column "B"

my formula on "C7":

=SUMIF($A$6:$A$18,A7,$B$6:$B$18)

gives 1.25

 

[DJ'sGiGi]

Yes, exactly like your's. Look for formats in column "B"

my formula on "C7":

=SUMIF($A$6:$A$18,A7,$B$6:$B$18)

gives 1.25

Thanks Sahak. I appreciate you verifying that my formula is correct.

I don't know what the deal is. I opened a new workbook and retyped the data and formula and it worked fine. For some reason it just won't work in my existing workbook. May just have to start from scratch.

 

[Sahak]

Good.

 

[AhoyNC]

Make sure the dates in your first workbook are actual dates and not formatted as text.

 

[DJ'sGiGi]

After spending about 2 weeks trying to figure out the problem with the post below, I've discovered that sumif is not working because the dates are a formula-based calculation. If I type over the formula and input values. the formula works fine. Is there any reason why Excel won't recognize the cells with the formula?

I need help with a SUMIF based on dates formula. I've compared my formula to another one the forum where the user was attempting to do exactly the same thing I'm trying to do. I have a column with dates and one with % of the day worked. I need to sum the time for cells with the same date to make sure the person has not worked more than 1.0 day on any given date. Columns A-C of the data and the formula I'm using look like this:

<PRE>
9/16/2014 OFF 0.00 "=SUMIF($A$6:$A$18,A6,$B$6:$B$18)"
9/17/2014 0.50 0.50
9/17/2014 0.75 0.75
9/18/2014 0.25 0.25
9/18/2014 0.00
0.00
0.00


</PRE>

As you can see, Excel is not totaling correctly because I should have 1.25 for 9/14/2014.

Your help and suggestions are appreciated.