On Tue, 2006-06-27 at 18:28 -0500, Peter Kupfer wrote: > Gerry -- > > The function worked (thanks) but the table still needs to have the #s in > column A and the G's in column B. The first term in the function is the > column with the cells to be evaluated against the criteria (2nd term in > function) and the third term in the function is the values to sum if the > criteria is met. > > OOC, did you know the char trick already or did you find via a search > somewhere. I am always looking to refine my search techniques. > > Thanks, > Peter >
Nope. Just remembered my use of BASIC from '72 that you need CHAR() for character literals. > > G. Roderick Singleton wrote: > > > > > Peter nad Ryno, > > > > Try =SUMIF(B1:B9;"<>CHAR(G)";A1:A9) as the incantation. With a table > > like this: > > > > 1 > > > > > > 2 > > G > > 3 > > > > > > 4 > > > > > > 5 > > G > > 6 > > > > > > 7 > > > > > > 8 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
