Forum Discussion
How to sum columns and cells with dates and simple criteria?
I admit, I am not very skilled at excel. I want to sum numbers in column B IF they have a key word in column C, AND exist within certain dates from column A. I then want that SUM to appear in a s...
Why don't you use a pivot table?
Thank you all for your help. I am going to learn a little more about pivot tables and will be back with more questions. Do Pivot tables work on the web version of Excel? I need it to work on the online Excel and couldn't get my VBA Macros to work properly on the web. Another question: IS there a way to have a blank row in the data columns so that when I enter the data and hit return, it sends the data down one row, and leaves the current row empty and ready for the next data to be input? Thank you all in advance.
