Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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