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: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2351518

Can'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.

Pete

On Fri, 3 Feb 2006 14:29:30 +0100, irresistible007
wrote:


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

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
http://xcell05.free.fr

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

3. For Euros:
=SUMPRODUCT((REGEX.FIND(XLM.GET.CELL(7,rng),"\x80" )0)*rng)


--ron

If it is any help =LEFT(CELL("format",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

"irresistible007"
wrote in message
...

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: http://www.hightechtalks.com/m63
View this thread: http://www.hightechtalks.com/t2351518