if formual how to use in two conditions, or any formula to give result from sum of two dat

**raysrains1310** · 01-29-2015, 08:01 AM

Hi,

Will appreciate help on this

I am looking for formula to give me numbers in attached file, got amount against two data /column. and got sum of different currency but also looking for sum of trade in currency relate to this.

want sum of Trade USD Trade EUR in cell M1 & M2 respectively

thanks

**Special-K** · 01-29-2015, 08:09 AM

in M1
=SUMPRODUCT((C$5:C$237="Trade")*(E$5:E$237=RIGHT(L1,3))*(B$5:B$237))
and copy down
in O1
=SUMPRODUCT((C$5:C$237="Intercompany")*(E$5:E$237=RIGHT(L1,3))*(B$5:B$237))
and copy down

I also checked totals of columns M and O equal the total of column B by the way so the summary covers all values in column B :-)

**samba_ravi** · 01-29-2015, 08:12 AM

M1=SUM(INDEX((TRIM($C$5:$C$237)&" "&TRIM($E$5:$E$237)=TRIM(L1))*($B$5:$B$237),0))
Try and copy across
m2:m3
and O1:O3

**raysrains1310** · 01-29-2015, 08:49 AM

Thanks to both of you, much appreciated

if formual how to use in two conditions, or any formula to give result from sum of two dat

LinkBack

Thread Tools

Rate This Thread

Display

if formual how to use in two conditions, or any formula to give result from sum of two dat

Re: if formual how to use in two conditions, or any formula to give result from sum of two

Re: if formual how to use in two conditions, or any formula to give result from sum of two

Re: if formual how to use in two conditions, or any formula to give result from sum of two

Thread Information

Users Browsing this Thread

Similar Threads

Looking for a formula that will give me the result. When entering customer account #

[SOLVED] Formula to give yes or no result based on cells data

Formual that Multiplies 2 columns to give a percentace based on 2 criteria

[SOLVED] using a max formula on a column with no data to give a Blank result

Formula to give maximum 100% even when result of formula exceeds 100%

Bookmarks

Bookmarks

Posting Permissions