Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to add all values in column F, (a+b+c etc, below) corresponding to a
description in column C of "08:15" and to ensure that any value corresponding to ANY TIME OTHER THAN 08:15 was NOT INCLUDED in the total Example: C1 contains the time "08:15" F1 contains the value to be added, which I will call "a" C365 contains the time "08:15" F365 contains the second value to be added which I will call "b" C729 contains the time "08:15" F729 contains the third value to be added which I will call "c" , etc etc Two questions, then: 1. What formula could I input to achieve the above, i.e. to get the sum of a+b+c ? 2. I also want to ensure that if one of the cells in column C showed a time other than 08:15 that the value in the corresponding column F was NOT added, so for example if C729 above had "08:30" instead of "08:15", I would not want value "c" above included in my total. Many thanks for your help !!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Adding a fixed date to a cell | Excel Worksheet Functions | |||
How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) | |||
Only using the correct cell for the sum | Excel Worksheet Functions |