June 6, 2017
Hi! Could you help me with this problem?
I've got data in the same format on mutiple sheets. I want to use the sumif function with multiple criteria across all sheets based on the data i have in row 1.
I have a formula that works with a single criteria, however when i try to use multiple criteria it fails.
Here is the formula I've tried to use:
(I named a range sheets, that contains all the names of my sheets.)
My overall goal is this:
i have monthly data for a year in each sheet, and i have cells on top month1; month2 etc.
I want a cumulated number for each row till a certain month. ( For example I'd like to sum the first three months) and i want it to be changeable. (Next month i need the first 4 months)
Could you help me with the formula, or do you have any other idea not using VBA?
Thank in advance!
June 25, 2016