SUMIF Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm hoping you can help with my SUMIF problem below, please see a sample of
data below.

Country OrderValue($)
UK 1000
UK 2000
UK 3000
FR 4000
FR 5000
FR 6000

Say I want to see the total value of UK order I would use the formula
=SUMIF(A:A,"UK") but this doesn't seem to work?

Thanks in advance,

Mo..
 
Assuming the data is in columns A and B, the formula requires the element to
sum i.e. column B

=SUMIF(A:A,"UK",B:B)
 
=SUMIF(A:A,"UK",B:B)

or

=SUMIF(A:A,"="&E2,B:B)

where E2 houses a country of interest like UK.
 
Back
Top