Return a month wise sum values with ignoring text values in date range and blanks.

Hi,

Required a formula help to return a month wise sum values with ignoring text values in date range, and also ignoring blanks as based on data column A to E, result to be return in column G to K.


Sample sheet with expected results are attached.


Thanks,

or just use basic SUMIFS

Formula:

Please Login or Register  to view this content.

Many Thanks for the solutions