I am trying to count a large group of cells that are colored depending on the data. For example: I want to count the number of red cells which are faults. I tried the countif but not sure how to set the criteria. Thanks for any help.

Hi. I am creaing a spreadsheet for work. Basically I have a column that shows all the project names, it shows a date and a price for the project. I need this price to then be automatically placed into the appropriate monthly column. I.e if the project is 20,000 and happened on the 21st of jan...

Hi, I am a new member, I hope you could help me to complete my assignment tonight, I am stock with "Count IF" function in Microsoft Excel 2003 How could I write the function with this commands: Count if the Tax which is (E15) not equal to 0, then I want to use a nested if with these...

In November 2004 Leif 5233 wrote the following regarding counting cells highlighted in a certain colour: ------------------ Create this function: Function CountCol(SumRange As Range, intColor As Integer) As Integer Dim I As Integer Dim Cell As Range Set SumRange =...

Could anyone know if there is any Excel function that I can use to remove a certain character from a text string, e.g. 1). Remove space from "acurve is what" 2). Remove "-" from "acurve-is-what" 3). Remove "'" from "acurve'is" And so on. Thanks a lot!