Anybody good at excel formulas?

[Dano]

Trying to work out how to do this in an easier manner...

=COUNTA(F4)*D4+COUNTA(F5)*D5+COUNTA(F6)*D6 and so on all the way down to row 45.

What I'm trying to do is add together the figures in column D but only where there is an entry (of any kind) in the corresponding monthly column so we get a total at the bottom of the monthly column.

Here's the sheet if you want to play: http://homepage.ntlworld.com/daniel.clarke17/arghhh.xls

I suck at this sort of stuff and have no idea how to simplify it due to a complete lack of knowledge and experience with excel, any help would be greatly appreciated

 

[Dano]

Thanks all, will report back when done

 

[Dano]

This does what you want:

=SUMIF(F4:F45, ">0", D445)

This works perfectly until it hits one of the columns with an 'x' in it, at which point it fails, now assuming (probably wrongly...) that the >0 section in the middle is checking for a value greater than zero can I change it to a test to check if the cell is empty?

 

[Dano]

Ok, after a little playing I discovered by accident that by using:

=SUMIF(F4:F45, "<>", D445)

works, is there anything bad about it? Seems odd using a does not equal operator with nothing to compare it to, or does it be default compare with nothing, hence it working as I want?

Thanks all

 

[Dano]

Awesome, thanks again