I have to calculate sum of CCA + Exgratia + Gratuity+ HRA + LTA + Medical
but these values are stores in single column "Allow amt" for all Employees
and Allow Desc contains CCA , Exgratia , etc,..
I have to calculate sum of CCA + Exgratia + Gratuity+ HRA + LTA + Medical
but these values are stores in single column "Allow amt" for all Employees
and Allow Desc contains CCA , Exgratia , etc,..
Copyright © 2021 Jogjafile Inc.
one way is to take the row sum by going to
Analysismenu and 'Totals -> Show row grand total'. One more way is to take sum of the values in another sheet and combine those in a dashboard.