Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if
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 |