the result #n/a from a sum if ??

[fireslguk]

{=SUM(IF(DATA!E2:E500="Mon",IF(DATA!G2:G500=1,1,0)))}

the above looks down column e for a mon and column g for 1 however my result is #n/a ? by the way both this column e and g does have #n/a because they are waiting for info to go in another cell and e and g column are lookups

how do i stop the formula picking up and returning #n/a ?

any ideas ??

 

[fireslguk]

please tell me its a problem thats crackable ?

 

[just_jon]

I think you'll have to clean up your data range; see this fine post for some methods.

 

[fireslguk]

i used

Manipulate the vlookup part of the following formula to adjust to your requirements

=IF(ISNA(VLOOKUP(A6,$A$1:$B$2,2,0)),0,(VLOOKUP(A6,$A$1:$B$2,2,0)))


I hope this would help

Regards
Asim

which got rid of mee #n/a and now works cool