Innings Pitched Formulas

At least through Excel 2010, INT and MOD don't accept 3D references, and DOLLARDE isn't array compatible.

Why not put all the data on one sheet and record outs rather then innings? Then you can sum in the usual boring way and convert to innings.

Thanks for reply. My apologies, I should have stated in original post that I've gotten at least two of these formulas from previous threads from this site except they were originally written to add numbers from a column while I am trying to convert to adding from multiple sheets. This is where I'm having issues. I have done this previously years ago and it worked. Unfortunately all of my work was deleted on me one day while I was at work because of how much time I was spending on my sports stuff... But I have had this work properly before but I cant remember exactly what I did and at this point I'm banging head against wall. I'd prefer to do it this way for aesthetics and time.