G
Guest
Is there a way to combine these two functions
=sum('KG 43:RC 4Z'!C:C)
=SUMIF('KG 43'!$B:$B,TOTALS!$B7,'KG 43'!C:C
There are about 25 worksheets, each representing a different facility budget. The object is to search across all the worksheets for a specific accounting code and total the corresponding data. I know that I could do the sumif for each sheet but the formula gets a little long and makes adding and subtracting sheets later-on rather difficult
Thanks in advance
Brya
=sum('KG 43:RC 4Z'!C:C)
=SUMIF('KG 43'!$B:$B,TOTALS!$B7,'KG 43'!C:C
There are about 25 worksheets, each representing a different facility budget. The object is to search across all the worksheets for a specific accounting code and total the corresponding data. I know that I could do the sumif for each sheet but the formula gets a little long and makes adding and subtracting sheets later-on rather difficult
Thanks in advance
Brya