Thread: SUM of Hex?
View Single Post
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

You may need a helper column where you convert from HEX to DEC (using
function HEXTODEC) and then sum that column. Convert back to HEX using
DECTOHEX function.

"GeeB" wrote in message
...
OK...this is probably a very simple answer, but I can't seem to find it...

I have a column of hexidecimal numbers (0x20, 0x40, etc.) that I want to
simply present the SUM of that colum in Hex. I've been unable to get the

SUM
function to do this. What am I missing?