count a value in cell if the cell to the left has a certain Value
 

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.

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.