'If' Query
 

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.

'If' Query
 

=SUMIF(A2:A20,"Holiday",B2:B20)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Prady" wrote in message
...
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.

'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.

'If' Query
 

Thanks a lot Bob and Mike.... It really helped me..

Thx,
Prady

"Mike H" wrote:

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.