Dear Pecoflyer,

Though I got the solution, for 4 series and for 5 series I have to plot separate formula to get the result for sum of 4 series and 5 series.

1. Can it be in single formula ?
2. Currently to get the result, I have to put formula in each line in I and J column. Is it possible to select criteria at range level i.e. month range A5:A13, Code range B5:B13, sum table D5:G13 and month criteria H3 to get the sum of 4 & 5 series ?

Demo file is attached for your reference.

Thanks in advance

Attached Files

Demo - sum based on criteria 080324.xlsx (12.1 KB, 5 views)