software

I am having two sorts of Values one in USD while another in Euro....
this creates prob while doing conditional summing... it checks the
conditions and sumup all values falling into whether Euro and USD
values.... this is a huge prob 4 me since i dont know how to tell Excel
not to sum Euro into USD

I havent typed the formula yet but i inadvace know what will happen
.... here is the sample Data

A B
John $500
Silvester $600
John ?300
Silvester ?300

Now if i wanted to sum for John it would simply give me $800 where as
it should give me $500 for dollars and ?300 for euros--
irresistible007------------------------------------------------------------------------
irresistible007's Profile: www.hightechtalks.com/m63
View this thread: www.hightechtalks.com/t2351518Can't you use another column to specify whether Euros or dollars with
some simple code like E or D? How about one column for dollars, another
for Euros?

Hope this helps.

PeteOn Fri, 3 Feb 2006 14:29:30 0100, irresistible007
gt; wrote:

gt;
gt;I am having two sorts of Values one in USD while another in Euro....
gt;this creates prob while doing conditional summing... it checks the
gt;conditions and sumup all values falling into whether Euro and USD
gt;values.... this is a huge prob 4 me since i dont know how to tell Excel
gt;not to sum Euro into USD
gt;
gt;I havent typed the formula yet but i inadvace know what will happen
gt;... here is the sample Data
gt;
gt;A B
gt;John $500
gt;Silvester $600
gt;John ?300
gt;Silvester ?300
gt;
gt;Now if i wanted to sum for John it would simply give me $800 where as
gt;it should give me $500 for dollars and ?300 for euros

Here's one way. It relies on whether or not there is a Euro symbol in the cell
format string. That symbol has an ASCII Hex value of 80.

rng is the range to Sum (e.g. B2:B100) and cannot be an entire column.

1. Download and install Longre's free morefunc.xll add-in from
xcell05.free.fr

2. For Dollars:
=SUMPRODUCT((REGEX.FIND(XLM.GET.CELL(7,rng),quot;\x80quot; )=0)*rng)

3. For Euros:
=SUMPRODUCT((REGEX.FIND(XLM.GET.CELL(7,rng),quot;\x80quot; )gt;0)*rng)--ron

If it is any help =LEFT(CELL(quot;formatquot;,A1),1) return C is cell has $ and G
with ?300
Might be different in regions where $ is not the national currency.
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;irresistible007quot; gt;
wrote in message
...
gt;
gt; I am having two sorts of Values one in USD while another in Euro....
gt; this creates prob while doing conditional summing... it checks the
gt; conditions and sumup all values falling into whether Euro and USD
gt; values.... this is a huge prob 4 me since i dont know how to tell Excel
gt; not to sum Euro into USD
gt;
gt; I havent typed the formula yet but i inadvace know what will happen
gt; ... here is the sample Data
gt;
gt; A B
gt; John $500
gt; Silvester $600
gt; John ?300
gt; Silvester ?300
gt;
gt; Now if i wanted to sum for John it would simply give me $800 where as
gt; it should give me $500 for dollars and ?300 for euros
gt;
gt;
gt; --
gt; irresistible007
gt;
gt;
gt; ------------------------------------------------------------------------
gt; irresistible007's Profile: www.hightechtalks.com/m63
gt; View this thread: www.hightechtalks.com/t2351518
gt;