I know I need to use a vlookup. My workbook has 20 worksheets. The first
sheet is where I need the formula. I need the total from each of the other
pages. But based on days past due. If less than 30, more than 30 but less
than 60, like that.
The days past due are in column g.
I need the sum from column e of all the ones that are past due (less than
30, or more than 30 but less than 6o,)
Like this the past due has 55 days then the result from colum e needs to be
returned but with all the other results from column e that are also in that
category.