'If' Query
With the status in column A and the amount of time in column B try:-
=SUMIF(A1:A100,"=holiday",B1:B100)
Mike
"Prady" wrote:
Hi,
Im developing a Time tracker spreasheet for my team.
In this i have some fields - 'Status', a list that contains {Office,
Holiday, On Leave} and Hours field.
At the bottom of the sheet i have columns - Total Utilized Hours, Total
hours on Leave.
My query is that i have to calculate the Total Hours on Leave (only the
fields that have Status='Holiday' and its respective Hours).
Kindly help me.
|