Search code examples
excelexcel-formulaexcel-2013

Working with formula's

I'm creating a revision timetable in excel with drop down menus for each subject but I wanted to have a separate table to show how many hours of each subject I've revised for. What formula could I use to do this and how would I structure the formula?

Thanks

Dylan

Solution

  • What you're looking for is COUNTIF

    =COUNTIF(B3:E9,"History")

    or, if you were to put your subjects in column K, you could reference them directly so you can copy paste your formula down. 

    =COUNTIF(B3:E9,K1)

    Where K1 is the cell with a subject name in it.