Its been along time since Ive used excel and have cant remember for the life of me how to do this!
Im trying to count all the cells that have the letter 'L' when the cell on its left is 'html'. this can appear many times in a single spreadsheet. so say Colum A has different text values but when 'html' appears with the value 'L' in Colum B it will addup the number of times this mixture apears.
Does this even make sense? im so busy im starting to pull my hair out trying to figure this out, does anyone know the formula
Im trying to count all the cells that have the letter 'L' when the cell on its left is 'html'. this can appear many times in a single spreadsheet. so say Colum A has different text values but when 'html' appears with the value 'L' in Colum B it will addup the number of times this mixture apears.
Does this even make sense? im so busy im starting to pull my hair out trying to figure this out, does anyone know the formula
