try sumproduct()
=sumproduct(--(c5:c19=58),--(f5:f19="text"))
the --( changes the logical yes/no to 1 or 0 respecively

"Amandle" wrote:

I am trying to find a formula for a spreadsheet. These are the arguments
"CountIf C5:C19="58" & F5:F19="Text" Can someone help me?

I am trying to count the number of times the number 58 occurs with each
company name.

Thank you