Hi,
I am using sumif function with indirect to get data from multiple sheets which works fine but what I dont understand is how to nest so that it sums from every month instead of changing it manually for each month.
This is the function i am using:
=SUMPRODUCT(SUMIFS(INDIRECT("'"&$A$9:$A$14&"'!"&"C:C");INDIRECT("'"&$A$9:$A$14&"'!"&"$A:$A");$B$9))
I need a function in order for column "C:C" to change as i drag the cell for coming month.
Attached worksheet (marked roes in red)!
Bookmarks