I'm trying to, with one formula, get Excel to work out if a column of USD amounts are, individually, >=HKD100,000.00 when converted. I've got a column of USD amounts and a USD/HKD conversion rate on the worksheet. I want Excel to tell me how many of the USD amounts in the column are >=HKD100,000.00 when converted.
I'm a bit of an Excel novice, so i've been trying to combine COUNTIF criteria without much luck. Getting round the problem, at the moment, by converting the USD amounts into HKD, in the column next to the USD amounts and then employing a simple COUNTIF statement to work out how many of them are over >= HKD100,000.00 in value. But we're dealing with thousands of individual amounts and the aim is to setup a trim and efficient template for the next time we do this.
So USD amounts in Column A
The amounts converted into HKD in Column B
A COUNTIF statement to count how many of the values in Column B are >= 100,000.00
Thanks in advance.
Bookmarks