|I am trying to create a formula to work with text entries only the way that the SUMIF formula works with numbers.|
I will try my best to explain exactly what I need. Basically I need to keep a record of all the electrical cables I have installed according to their size.
I have three columns on my spreadsheet A,B and C and say 10 rows for example.
Column A contains details of each cable location
Column B contains details of each cable size, 10mm, 25mm, etc.
Column C contains the date each cable was installed
What I want to do is say count how many 10mm cables I have installed by simply counting the completed cells with dates in column C but only if the adjacent cell in column B says 10mm.
I hope this makes sense