LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking up multiple values in an arrray idaho_bruce Excel Worksheet Functions 5 September 12th 08 04:02 AM
{SUM(IF((ARRRAY FORMULA)} bookman3 Excel Worksheet Functions 8 October 18th 07 04:43 AM
Set a 2D arrray data into a range, given the top-left cell Tom Chau Excel Discussion (Misc queries) 2 June 29th 06 06:53 AM
Commenting custom formula fields/formula on formula editor Muxer Excel Programming 2 July 24th 03 01:02 AM


All times are GMT +1. The time now is 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"