I have a workbook with multiple sheets. In the main sheet, I have to output SUMIFS according to the scheme:
in next sheet formula should look like:Please Login or Register to view this content.
next:Please Login or Register to view this content.
and so on. So I have to jump 3 columns in the data sheet every time I copy a formula to the next column And so about 100 times. I've read a lot of threads already, but still can't get the formula to skip the columns properly. Anyone have an idea how to solve this?Please Login or Register to view this content.
Bookmarks