Posted to microsoft.public.excel.programming

Rashid[_4_] Rashid[_4_] is offline

external usenet poster

Posts: 2

sumif statment

Hi to All.

How would i write a sumif statment using the first character (left
function) of WH range to pull the data into the Final Values

original LIST
WH VALUE
A4 15,000
A6 6,500
B4 -313,079
BZ 20,000
C4 -335,343
D4 -393,476
H3 500,000
H4 3,200,000

FINAL VALUES - sumif
WH VALUE
A 21,500
B -293,097
C -335,343
D -393,476
H 3,700,000

Thanks,

Rashid

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
If statment help	Joe Wildman[_2_]	Excel Worksheet Functions	3	February 16th 09 07:16 PM
If statment	Jason	Excel Discussion (Misc queries)	3	January 3rd 08 11:39 PM
if statment	Dreamstar_1961	Excel Worksheet Functions	5	April 17th 07 01:30 PM
If statment if its possible.	atb	Excel Discussion (Misc queries)	2	October 17th 06 05:50 PM
SumIF Statment	[email protected]	Excel Discussion (Misc queries)	1	September 14th 06 06:29 AM

All times are GMT +1. The time now is 06:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us