I have one column in a different tab that displays monthly data. I need to SUM that monthly data into quarterly #'s in a row on a separate tab. I believe I can use SUM(Offset but am unsure of the exact formula
I'm sorry, but I still don't understand what result you want. That's why I asked for examples so that with the examples you explain what you have and what result you want.
One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data, its layout and the overall objective for it).
My apologies. I can't post the data since it is confidential but below is a very simple example. I need to take what is in column Y from one sheet and sum or average into a quarterly format like in the second sheet. Any help would be a appreciated.