Multiplying cell total based on value

[SLHayden]

I need a formula that will count the number of cells that "=missing" then multiply that number of cells by a value in another cell.

So if 6 cell in a row have a value of missing the cell A7 will return a value of 6 time $2.00.

 

[Andrew Poulsom]

Example:

=COUNTIF(A:A,"missing")*B1

 

[SLHayden]

Andrew thanks you are an MVP. To pick your brain a little more can that be modified so that the criteria could be "missing" or "damaged"?

 

[SLHayden]

Never mind got it, thanks for the guidance.

 

[Sektor]

=COUNTIFS(A:A;"missing")*B1+COUNTIFS(A:A;"damaged")*B1

Or CSE:
=--SUM(COUNTIFS(A:A;{"missing";"damaged"})*B1)