hello


this is simple & i cant work it out. i am annoyed! however, i couldnt find
anything like this listed in the other postings, so i am slightly less
aggrieved!


what i want is a function that says;

if cells B2 to U2 inclusive are all blank, make this cell blank, if not sum
cells B2 to U2 inclusive

seems simple enough, right! so, i have been trying different IF functions,
but i cant get the ISBLANK function to accept multiple cells or a range. I
really dont want to type out a long handed AND formula for every cell in the
range

i cant see how to get ISBLANK to behave, can anyone enlighten me!


many thanks, please let me know if you need anymore info


cheers

jb