Formula Help

A

Amandle

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
 
B

bj

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