VBA(excel)

Write an algorithm that solves the problem below. You may use any combination of pseudo code or VBA syntax discussed in class. Remember to include the purpose, input, output, and body of the algorithm. Create an algorithm for an Excel worksheet that contains a column of numbers starting at cell B1. The algorithm adds the numbers together starting from cell B1 and stops when it encounters a cell with a SUM string. When adding numbers, the algorithm skips cells with numbers less than or equal to zero. After, the algorithm replaces the SUM in the worksheet with the sum of numbers.