I am a much newer into Excel. I am in charge of a School database. The schools excel sheet is complicated. I have shorened it for you so as to easy understand it.
Please see my Issue mentioned in the image below. Since there are thousands for Students and attendent hours for each day needs to be calculated. It has become very tedious as I have to find and replace the Cell references each day.
This formuala is been currently used =COUNTIF(C1:C8,"=Abil") for getting the number of attendent hours. c1:c18 denotes the day students count for one day.
My issue is that I need to refer a CELL (C13) instead of direct using the formula in Feild Instead of =COUNTIF(C1:C8,"=Abil"), I need something like =COUNTIF(Value(C13),"=Abil") to get the count of that particular day (say June 01).
I even tried with =COUNTIF(Cell("contents",C13),"=Abil") to get the cell reference, it did not worked.
I know that my issue is simple, I spend quite a long time for solving the issue, but was not able to do so.
Please do help
Thanks in advance.
Please see my Issue mentioned in the image below. Since there are thousands for Students and attendent hours for each day needs to be calculated. It has become very tedious as I have to find and replace the Cell references each day.
This formuala is been currently used =COUNTIF(C1:C8,"=Abil") for getting the number of attendent hours. c1:c18 denotes the day students count for one day.
My issue is that I need to refer a CELL (C13) instead of direct using the formula in Feild Instead of =COUNTIF(C1:C8,"=Abil"), I need something like =COUNTIF(Value(C13),"=Abil") to get the count of that particular day (say June 01).
I even tried with =COUNTIF(Cell("contents",C13),"=Abil") to get the cell reference, it did not worked.
I know that my issue is simple, I spend quite a long time for solving the issue, but was not able to do so.
Please do help
Thanks in advance.
