countif formula

[hsauve]

I am currently using a sumif formula to fill a cell and need to change it to a countif or counta formula (or something else) because the new columns I need to reference are text.

Here is what I am trying to do:

I have two worksheets that each contain a name that I need to match/lookup and if they do match I am counting other cells in a different column

=SUMIF('Daily Log'!B:B,Students!D2,'Daily Log'!F:F)

What I need to do is count the text entries in columns C:E instead if the names match in 'Daily Log'!B:B,Students!D2

Please help. I have tried a whole variety of things but obviously my Excel formula writing skills aren't great yet.

Thank you

 

[Magriza]

I think you're looking for the COUNTIF function:
=COUNTIF('Daily Log'!C:E,Students!D2)