Formula Question

[lightningmtv]

Hello,

I’m trying to create a formule that adds a given time to a total only if the checkmark in the collum next to it has been checked off.

Example
Colum F has
F2: 11:30
F3: 2:30
F4: 4:30

Colum G has
G1: Not checked
G2: Checked
G3: Checked

Will give a total of 7 hours.

Hope someone can help

 

[etaf]

you maybe able to use a SUMIF()
BUT what is the Check mark
is this a character specific
or the words TEXT

your rows dont match

SUMIF( G1:G4, "checked", F1:F4)

Book5
	E	F	G	H	I
1		11:30	checked
2		2:30	checked		14:00
3		4:30	Not checked
Sheet1

Cell Formulas
Range	Formula
I2	I2	=SUMIF(G1:G3,"checked",F1:F3)

Format the cell with the hours using
[H]:mm
then it will show over 24hrs

 

[lightningmtv]

check mark gives a true or false statement.

 

[etaf]

check mark gives a true or false statement.

sorry not following , maybe its something i dont know

if TRUE then
SUMIF( G1:G4, TRUE, F1:F4)

I used a lowercase a and a and marlett font type to get a tick mark - for an attendance spreadsheet, also loads of ways to get a checkmark - tick into excel -
but sorry , i'm not following , hopefully this will be obvious and simple to other members

dont suppose it will show here

Book5
	B	C	D
2
3		a
4
5
Sheet1

no