Sum a column range based on another column range for all sheets

  • [SIZE=14px]Hi!!!


    I have a excel workbook in which there are 1000+ sheets which are increasing. Now [/SIZE]I need to get total value of column "I" (Range "I7:I") for all sheets based on month (from date) in column "F" (Range "F7:F") where column "F" is date column in messagebox.


    Example: If I want to check the data for the month of February, 2018 in entire sheet then it will calculate the sum the values from column "I" and show it through message box.


    Help required.


    Thanks in advance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!