addikng cells only if another cell has an N in it

[bam12]

I am trying to add up only certains cells when a cells has an "N" in them the belolw table i want to add 2 50 +92+3 42 so total in a cell would be 6 82
the 2nd column is hours and 3rd column is minutes in decimal form

thanks in advance for any help

014	2	50	N
021	1	67
059		92	N
742	1
542	3	42	N

 

[etaf]

=SUMIF( D2:D100,"N",C2:C100)

assuming columns are A,B,C & D

Book1
	A	B	C	D	E	F
1	14	2	50	N
2	21	1	67			184
3	59		92	N
4	742	1
5	542	3	42	N
Sheet1

Cell Formulas
Range	Formula
F2	F2	=SUMIF(D1:D5,"N",C1:C5)

 

[DanteAmor]

The result is 5 hours and 184 minutes.
If you convert 184 minutes to hours, the result is 3 hours and 4 minutes.
The final result would be 8 hours and 4 minutes:

Dante Amor
	A	B	C	D	E
1		H	M		Sum
2	14	2	50	N	8 hours 4 minutes
3	21	1	67
4	59		92	N
5	742	1
6	542	3	42	N
Hoja1

Cell Formulas
Range	Formula
E2	E2	=SUMIF(D2:D6,"N",B2:B6)+INT(SUMIF(D2:D6,"N",C2:C6)/60) & " hours " & MOD(SUMIF(D2:D6,"N",C2:C6),60) & " minutes"

I don't understand how in your result you get 6 hours and 82 minutes.
Can you explain it?

----- --
I hope to hear from you soon
Respectfully
Dante Amor
----- --

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

My take on this

Fluff.xlsm
	A	B	C	D	E	F
1
2	14	2	50	N		6.84
3	21	1	67
4	59		92	N
5	742	1
6	542	3	42	N
7
Data

Cell Formulas
Range	Formula
F2	F2	=SUMIFS(B:B,D:D,"N")+SUMIFS(C:C,D:D,"n")/100