Formula Help
 

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

Formula Help
 

try
=sumproduct((c5:c19=58)*(f5:f19="Text"))

--
Don Guillett
SalesAid Software

"Amandle" wrote in message
...
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

Formula Help
 

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

Formula Help
 

Thanks alot!!

"Don Guillett" wrote:

try
=sumproduct((c5:c19=58)*(f5:f19="Text"))

--
Don Guillett
SalesAid Software

"Amandle" wrote in message
...
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