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