Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF Problem
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.. |
#2
|
|||
|
|||
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) "Mohammed Zenuwah" wrote in message ... 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.. |
#3
|
|||
|
|||
=SUMIF(A:A,"UK",B:B)
or =SUMIF(A:A,"="&E2,B:B) where E2 houses a country of interest like UK. Mohammed Zenuwah wrote: 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.. |
#4
|
|||
|
|||
=SUMIF(A:A,"UK",B:B)
Biff "Mohammed Zenuwah" wrote in message ... 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.. |
#5
|
|||
|
|||
Try
=SUMIF(A:A,"=UK",B:B) HTH "Mohammed Zenuwah" wrote in message ... 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.. |
#6
|
|||
|
|||
Hi All,
I just gave that a shot and it worked a treat. Thanks for the support. Mo.. "Mohammed Zenuwah" wrote: 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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem adding a range using Sumif function. | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions |