I am working in Microsoft Excel, and in one row I have cells with "R" that represent reconciled columns and cells that have either "*" or is blank. I want excel to find all the cells with "*" and blanks and return the sum of the matching columns. Can someone tell me the formula to do this? I have attached an image to show what I am talking about excel.jpg
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.