IF "exists at least one of this kind => xxx" conditional.

[Pablo Ferragut]

Please I need help with this kind of conditions...

I don't know how to do it when I have a large data range, in which only one missing / wrong value is enough to discard any calculation from this data range.

If there are only few cells, i put "if(or(a7="NDA";b7="NDA".........;g7="NDA");"NDA";SUM(a7:g7)) but i can't do that with large ranges. I think that maybe i have to use any kind of look up formulas, but i don't know how, can anyone help me, please???

thanks.

PS: It would be great if someone speaks spanish.

[Fotis1991]

Hi and welcome to the forum.

I don't speak Spanish but maybe i'll be able to give you a suggestion.

And best way to describe your problem is to upload s small sample workbook.

[FDibbins]

not sure if this is what you want, but perhaps instead of that big formula, try the below....

=IF(COUNTBLANK(A1:A11)>0,what-to-show-if-there-is-a-blank,what-to-show-if-there-is-NO-blank)