I then go to the Object Master page layout, click the wrench next to the Object Detail related list, and remove the New button and add the freshly created “New Object Detail” button: Go back to the Object Master record and confirm that it works.
Now we can use this column to test our condition by writing the sumif function as [learn how you can highlight alternative rows / columns in an excel table] Often when you are working on data spread across multiple sheets, it helps to know how many times each item on one list is repeated in another list(s).
Sumif function sums a range of data that meets a specific criteria.
In our case the criteria will be, “if the data element is in odd number rows”.
The formula looks like would tell us how many customers are in Chicago.
Now that we have figured out how to use sumif and countif, you can use these two functions to create quick summary of your data.
However when I try the button I just get the message: “A problem with the On Click Java Script for this button or link was encountered: Unexpected identifier”.