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
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]
