SUM only certain ones

[crazyd]

I asked this before, but I think I may have asked it wrong.
I have a driving log. In column D5 thru D73 is to put either Day or Night. In Column F5 thru F73 is total drive time. I need at the bottom of the sheet to have a total for all day time and a different total adding all of the ones that say night. Is this possible?

 

[Brian from Maui]

http://www.mrexcel.com/board/viewtopic.php?topic=20894&forum=2

 

[texasalynn]

On 2002-09-03 06:59, crazyd wrote:
I asked this before, but I think I may have asked it wrong.
I have a driving log. In column D5 thru D73 is to put either Day or Night. In Column F5 thru F73 is total drive time. I need at the bottom of the sheet to have a total for all day time and a different total adding all of the ones that say night. Is this possible?

Try this:
=SUMIF(D5:D73,"Night",F5:F73)

HTH
texasalynn

 

[Geert]

Hi Crazyd,

you can use the SUM.IF function to select what you want to total.

total:=SUM(F5:F73)
total day:=SUM.IF(D5:D73,"Day",F5:F73)
total night:=SUM.IF(D5:D73,"Night",F5:F73)

Geert

 

[crazyd]

Ok sorry, I didn't fully read the message. Thanks for the help. It worked great.