count specific values in a column
Hi, I have the following table and want to calculate Date /Time Status ------------------------------------- May 1 00:01 pending May 1 00:05 accepted May 5 11:01 accepted May 6 12:01 finished I want to calculate acceptance rate, which is the ratio of #(accepted+finished)/#total How can I use the count function to count…