S
soph
Hi all
I know this should be easy but I am having no luck so any help would be
great!!
I have two columns, column B for attendance (which is populated by an "x" if
attended) and column A for the number of hours attended. I want a total
number of hours attended, so am trying to say "if there is an x in column B,
then sum column a". I thought it would just be
if((B4-B195="x"),sum(a4:a195),"")
however it keeps returning a "value" error or sums the entire column
regardless of the attendance. Help!
Cheers
Soph
I know this should be easy but I am having no luck so any help would be
great!!
I have two columns, column B for attendance (which is populated by an "x" if
attended) and column A for the number of hours attended. I want a total
number of hours attended, so am trying to say "if there is an x in column B,
then sum column a". I thought it would just be
if((B4-B195="x"),sum(a4:a195),"")
however it keeps returning a "value" error or sums the entire column
regardless of the attendance. Help!
Cheers
Soph