Thread
:
Calculation on SUMIF Results
View Single Post
#
3
Sandy Mann
Posts: n/a
If I understand you correctly, with the data given in A1:D5 try:
=SUMPRODUCT((B2:B5="GBP")*(C2:C5)*(D2:D5))
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"Andy B" wrote in message
...
Hi all,
I have a bit of a proble, I want to perform a rate calculation on the
results of a sumif i.e.
Customer Currency Rate value
1 USD 1 500
2 GBP .7 700
3 GBP .71 750
4 GBP .72 700
So I want to get the native currency for all GBP paying customers but the
rates are different so I cant just divide the rate at the end, it needs to
be
done on the fly. This problem is on a standard report so I can't just
convert
all the values on a separate column and do the sumif on the results.
Any Ideas would be v helpful
Reply With Quote