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...
I've attached a demo with two solutions: pivot table, PIVOTBY.
If your date column is clean and not text then this is straightforward.