Hi
I'm sure this is a very basic formula but I need help.
In a single cell I want to it return a numerical value for every cell that has a particular word included in its cell. I am trying to use the following formula but perhaps I am using the wrong one;
=COUNTIF(B1:B10,"£70")
Column B = Cost of Fee
I want it to calculate the sum of any cell that contains £70 between B1:B10. If there were only two cells between B1:B10 then it would return £140.00. Other cells within the range may contain I another figure so I only want it calculate those with a particular word included the cell.
Help would be greatfully appreciated.
Regards
I'm sure this is a very basic formula but I need help.
In a single cell I want to it return a numerical value for every cell that has a particular word included in its cell. I am trying to use the following formula but perhaps I am using the wrong one;
=COUNTIF(B1:B10,"£70")
Column B = Cost of Fee
I want it to calculate the sum of any cell that contains £70 between B1:B10. If there were only two cells between B1:B10 then it would return £140.00. Other cells within the range may contain I another figure so I only want it calculate those with a particular word included the cell.
Help would be greatfully appreciated.
Regards