View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default help with arrray formula

can someone help me out with an array formula again?

range e4:e56 will contain a number most of the time
this number can be appended with an x. over in column g there will be an
amount. the x will always be the last character
1234 1000
5678x 500
135 200

i need a formula to sum column g4:g56 based on each condition, each in a
separate cell.
one result = 1200. the other = 500

can somebody help?


--


Gary