[Solved] Apply formula to entire sheet

[xorg]

I have a sheet, basically a calendar. One cell=one day. Each cell will ultimately have one of four "string" values. I need a formula that searches the entire sheet. If the string RDD is entered in any cell a simple sum, +10 for each occurrence, will be performed.

[MrProgrammer]

I need a formula that searches the entire sheet. If the string RDD is entered in any cell a simple sum, +10 for each occurrence, will be performed.

If you want to count how many times a range of cells has the value RDD, and multiply that count by 10, the formula is =SUMPRODUCT(A2:G6="RDD")*10, where A2:G6 is the range to be checked.

[Tutorial] The SUMPRODUCT function, examples X25 through X27.

If you need any additional assistance attach a spreadsheet demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach a spreadsheet document. The only way a formula can apply to an entire sheet is to put it on a different sheet, since a formula can't apply to itself.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know