Forum Discussion
Requesting help to programme a spreadsheet
Hello Jeffry
I think this is related to "Problem with IF function".
You can use a mix of Ingeborg's and my solution.
Insert an additional column after "Duration" with this formula and copy it down.
=LOOKUP(I3,{0,10,56.0001},{"Hot","Warm","Cold"})In the same column you have to write the types:
K12: Cold
K13: Warm
K14: Hot
And put this formula in C12 and copy it down and to the right.
=COUNTIFS($A$3:$A$5,C$11,$K$3:$K$5,$K12)
Hello Jeffry
I think this is related to "Problem with IF function".
You can use a mix of Ingeborg's and my solution.
Insert an additional column after "Duration" with this formula and copy it down.
=LOOKUP(I3,{0,10,56.0001},{"Hot","Warm","Cold"})In the same column you have to write the types:
K12: Cold
K13: Warm
K14: Hot
And put this formula in C12 and copy it down and to the right.
=COUNTIFS($A$3:$A$5,C$11,$K$3:$K$5,$K12)
Dear Mr. Detlef,
That was very helpful. Hope you could help me to resolve one final hurdle with the spreadsheet.
Everyday, new data will be keyed in into the row 3 to 5. Meaning, the engineers will delete yesterday's data and key in today's data.
But the accumulated start-up table (row 12-14) should not reset when the data in the top table is deleted and new data is keyed in. Because we can only measure the total start-up if the bottom table adds up all the start-up.
Hope you can help me, sir.
Thank you.
P.S. I have attached the edited file as per your instruction.
This can't be done with formulas. May be it can be done with VBA.
But you better should consider redesigning your setup and put everything in a big table - and especially without any merged cells.
See the uploaded file.
- Thank you very much, Mr. Detlef.
Really appreciate it.
