If Formula?
 

I need to arrive at the total percentage of time entered in all of Column B
(based on 24 hours) ONLY IF column A has the letter "C" in it. I'm having
trouble with my formula. Can someone help please? Example:

A B

C 2:30
L 3:40
W 1:00
C 1:00

If Formula?
 

Assuming real times in col B
In say, C1: =SUMIF(A:A,"C",B:B)
Just format C1 as percentage to taste
C1 will return the required percentage over 24 hours
(24 hours is equivalent to an underlying value of 1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Nanapat" wrote:
I need to arrive at the total percentage of time entered in all of Column B
(based on 24 hours) ONLY IF column A has the letter "C" in it. I'm having
trouble with my formula. Can someone help please? Example:

A B

C 2:30
L 3:40
W 1:00
C 1:00

If Formula?
 

Try this:

=SUMIF(A1:A4,"C",B1:B4)*24/24

Format as Percentage

--
Biff
Microsoft Excel MVP


"Nanapat" wrote in message
...
I need to arrive at the total percentage of time entered in all of Column B
(based on 24 hours) ONLY IF column A has the letter "C" in it. I'm having
trouble with my formula. Can someone help please? Example:

A B

C 2:30
L 3:40
W 1:00
C 1:00

If Formula?
 

Thanks very much to T. Valko and Max for taking the time to help me out. One
more question, please. I want to calculate the percentage of the "C"s in
column A, compared to ALL of column A. Can you help me once more?

"T. Valko" wrote:

Try this:

=SUMIF(A1:A4,"C",B1:B4)*24/24

Format as Percentage

--
Biff
Microsoft Excel MVP


"Nanapat" wrote in message
...
I need to arrive at the total percentage of time entered in all of Column B
(based on 24 hours) ONLY IF column A has the letter "C" in it. I'm having
trouble with my formula. Can someone help please? Example:

A B

C 2:30
L 3:40
W 1:00
C 1:00

If Formula?
 

Thanks very much to T. Valko and Max for taking the time to help me out.

Welcome. Please go back and press the Yes* buttons in all responses which help
*like the ones below, from where you're reading this

I want to calculate the percentage of the "C"s in
column A, compared to ALL of column A

Assuming no column header in A1, then:
=COUNTIF(A:A,"C")/COUNTA(A:A)
Format as percentage

If there is a column header in A1, adjust it like this:
=COUNTIF(A:A,"C")/(COUNTA(A:A)-1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---