Posted to microsoft.public.excel.programming

GregR

external usenet poster

Posts: 246

More formula help

I have this formula which is not giving the expected results

=SUMPRODUCT(LEFT(K5:K1002,1)="8",(A5:A1002)=TRUE,( Y5:Y1002))

The result I am getting is 0. What I am trying to achieve is to sum the
numbers in Y5:Y1002, if the corresponding cell in K5:K1002 begins with
an "8" (account # entered as text, example, 800-000-900) and the
corresponding cell in A5:A1002 is not blank. TIA

Greg

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
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 08:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us