I have 20 identical worksheets with identical tables in each. I need to (on a separate worksheet) sum the columns [TOTAL COST] based on the values in the columns [MATERIAL ACCT#] & [ACCT TO BE DEBITED:]. Of course, I could use the super long formula, but know there's an easier way. I am not versed in Macros or VBA, yet!
My super long sample formula would begin like the one below, but of course, go out to 20 tables:
=SUM((SUMIFS(COSTSHEET1[TOTAL COST],COSTSHEET1[MATERIAL ACCT'#],B26,COSTSHEET1[ACCT TO BE DEBITED:],2003.3)),(SUMIFS(COSTSHEET2[TOTAL COST],COSTSHEET2[MATERIAL ACCT'#],B26,COSTSHEET2[ACCT TO BE DEBITED:],2003.3)),(SUMIFS(COSTSHEET3[TOTAL COST],COSTSHEET3[MATERIAL ACCT'#],B26,COSTSHEET3[ACCT TO BE DEBITED:],2003.3)))
Thank you!!!
Bookmarks