Thread: Excel count function for specific cells

Hi,
I have a spreadsheet and I am trying to use a count function for data in specific columns only
e.g.
Column A: 1
Column B: 3
Column C: (A+B) 4
Column D: 4
Column E: 0
Column F: (D+E) 4
I am trying to get a count of the number of columns that contain the value 4 but only as an input value as opposed to the sum of any other values (if that makes sense), in this case I do not want to include columns C or F in my count function.
Anyone any suggestions?
Thanks

Thanks zbor,
The range of columns I am interrogating is over 100 with the formula every 3 cells, would be hoping for a slightly more efficient way of doing this if possible
Regards