R
Rob
I am trying to calculate the total time in one cell, if another cell equals a
certain test.
Example:
A B C D
1 :15 1S
2 1:00 2S
3 :45 3I
4 2:00 1S
So i have a countif formula that counts cell 1C, but where i am having
problems is if 1C equals 1S, then i want it to add cell 1B. And then in that
same cell, it would also see cell C4 and add cell B4 to it.
I hope this make some sense.
Any help would be great!
Thanks
Rob
certain test.
Example:
A B C D
1 :15 1S
2 1:00 2S
3 :45 3I
4 2:00 1S
So i have a countif formula that counts cell 1C, but where i am having
problems is if 1C equals 1S, then i want it to add cell 1B. And then in that
same cell, it would also see cell C4 and add cell B4 to it.
I hope this make some sense.
Any help would be great!
Thanks
Rob