Hello guys,

I have used sumiff to add up my inter-company recharges based on dept, finanical year, and financial period (e.g month).

the formula below works by saying

=IFERROR(SUMIFS(data!$D$2:D92166,data!$B$2:B92166, $D$2,data!$C$2:C92166,$D$3,data!$A$2:A92166,$D$4), "-")

look at the data range data!$D$2:D92166 and sum dependent on the chosen financial year ($D$2), financial period ($D$3), and department ($D$4).

I am however struggling to find a formula that show the cumulative year-to-date amounts if say March is chosen. It should show the sum of January to March from the same column that contains various entries from Jan to Dec.
I'm not sure i can use SUMPRODUCT with ISNUMBER as i want to add all amount from Jan to the chosen period. I have used numbers to represent the periods (e.g. 1 to 12).

Any help would be greatly appreciated.

Thanks,
Jay