Sum help!

[Louise_douglass]

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!!

 

[njimack]

Excel Workbook
	A	B	C	D
1		A	B	C
2		LONDON	SWISS	FRANCE
3	Q1	100	100	100
4	Q1	100	100	100
5	Q2	100	100	100
6	Q2	100	100	100
7
8	A
9	LONDON
10	Q1
11
12	200
Sheet1