Msaada: Wataalaamu wa excel

[pandagichiza]

Nimeweka data column A na B column C nimeweka formula ya average nataka nikopy hiyo formula kwa Ku-drag ili ninapo ingiza data column A na B inipe average column C lakini haileti average. Nifanyaje?

 

[Jimena]

Jaribu kukopi file zima, usidrag copy file lote kisha paste kwenye new page then futa column a na b, C itajifuta yenyewe na fomula itabakia

 

[Sizinga]

Kama ni average basi formula ikae kwenye hizo columns A & Bana si vinginevyo

 

[pandagichiza]

Jaribu kukopi file zima, usidrag copy file lote kisha paste kwenye new page then futa column a na b, C itajifuta yenyewe na fomula itabakia

nimefanya hivyo.lakini kila nikiingiza data column A na B hailet average mpaka niandike formula upya kila cell