Conditional Add Formula

[CountrySmiles]

I have figured out how to set conditions to add amounts based on complete
cell values.

What I want to know is if I can set a condition that will add a specified
cell if another cell contains a certain value.

For example. I have a cell with numbers and text which reads something like
075555 AAAAAAAAA... and another cell in that column which reads 375555
BBBBBBB. What I want is for the formula to pick up the first two numbers
only. So 07 and 37 (as I could have multiple descriptions in that column but
the descriptions will always start with either 07 and 37).

I want the sum of the descriptions starting with 07 and the sum of the
descriptions starting with 37. Is there a way to do this?

 

[RagDyeR]

I assume you want the *count* and not the "SUM".

=COUNTIF(A1:A100,"07*")

=COUNTIF(A1:A100,"37*")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have figured out how to set conditions to add amounts based on complete
cell values.

What I want to know is if I can set a condition that will add a specified
cell if another cell contains a certain value.

For example. I have a cell with numbers and text which reads something like
075555 AAAAAAAAA... and another cell in that column which reads 375555
BBBBBBB. What I want is for the formula to pick up the first two numbers
only. So 07 and 37 (as I could have multiple descriptions in that column but
the descriptions will always start with either 07 and 37).

I want the sum of the descriptions starting with 07 and the sum of the
descriptions starting with 37. Is there a way to do this?