More than 7 arguments in a formula II

[krislyn]

I read the thread on Embed more than 7 formulas in one, and it helpe
for IF statements, but what about when the formula calls for jus
summing rather than an IF statement?

I am adding one cell from several spreadsheets into one total report o
the main sheet
Here are the fomulas that I had to split.

=SUM(LINDA_P!C20+DEB_R!C20+JASON_E!C20+TINA_V!C20+KIM_D!C20+TODD_P!C20+KRIS_T!C20+KELLEY_M!C20+BRIAN_D!C20+JON_H!C20+LAURA_R!C20+MARTY_M!C20+JULIA_G!C20+DEANNA_G!C20+SHEILA_H!C20+JILL_M!C20+SUSAN_S!C20+DETTA_T!C20+ADAM_G!C20+SHERYL_T!C20+SUE_A!C20+JANE_Y!C20+MARCY_B!C20+CINDY_G!C20+KATHY_H!C20+JOANNE_H!C20+DIANE_S!C20+AMANDA_W!C20)
and
=SUM(RUKHSANA_Z!C20+BRITTAN_B!C20+JULIE_G!C20+HEATHER_K!C20+HOLLY_M!C20+TAMMY_P!C20+PATTY_S!C20+KEVIN_T!C20+CATHY_J!C20+MONA_M!C20+HEIDI_T!C20+SUSAN_SCH!C20+SAMMY_A!C20+JANE_Y!C20+ANDREA_G!C20+EXTRA3!C20+EXTRA4!C20+EXTRA5!C20)

Thanks!
Krisly

 

[Ken Wright]

Are these sheets all contiguous in the same workbook? If so then assuming
Linda_P has the second sheet, Extra5 is the last sheet, then on the main sheet
which I assume will be sheet1, use the following:-

=SUM(Linda_P:Extra5!C20)

This will sum ALL sheets between and including those two.

 

[krislyn]

Thanks Ken! It's so nice to have the experts at my fingertips!
My experience in Excel is all self trial/error, mostly error!! Thank
again!

Krisly