# Sum help!

#### Louise_douglass

##### New Member
Hi there,

I am trying to use a sum function that has variables on both the column and row...So a Sumifs is giving me a value error.

As an example

 A B C LONDON SWISS FRANCE Q1 100 100 100 Q1 100 100 100 Q2 100 100 100 Q2 100 100 100

<tbody>
</tbody>

So i am looking to sum if row 1 says A and London and col. =Q1

Hope this makes sense!! Thank you!!

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Excel Workbook
ABCD
1ABC
2LONDONSWISSFRANCE
3Q1100100100
4Q1100100100
5Q2100100100
6Q2100100100
7
8A
9LONDON
10Q1
11
12200
Sheet1

Replies
1
Views
291
Replies
3
Views
262
Replies
3
Views
404
Replies
4
Views
372
Replies
1
Views
261

1,196,481
Messages
6,015,451
Members
441,896
Latest member
clomah

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back