Thread: count a value in cell if the cell to the left has a certain Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default count a value in cell if the cell to the left has a certain Value
If you mean summing the values from column B when Column A is "State Farm"
then:
=SUMIF(A:A,"State Farm",B:B)

"Staholly" wrote:

What formula can I write to count value in one cell if left cell value is a
certain criteria

Ex.
Column1 Column2
State farm 300


If Column has state farm count column 2's value.
Reply With QuoteReply With Quote