Multiple SUMIF

[mar050703]

Hi Guys

I have the following in Row 2 Column B:M April - March
Column A3:A68 are countries. What I want to do as add the value for each country dependant on a selected Month say in A1, and the selected Country is B1, in C1, I would have the value for the relevant Month and Country.

Please can you help?

 

[SkipVought]

Hi,

Please keep in mind that we have ONLY your description and cannot see what's in your head.

"add the value for each country " What value?

I'm assuming that you have values for each country by month.
[tt]
C1: =sumproduct({B2:M2=A1}*(A3:A68=B1)*(B3:M68))
[/tt]




Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[yogia]

Hi mar050703:

How about ...

=SUM(INDEX(B3:M68,MATCH(B1,$A$3:$A$68,0),MATCH(A1,$B$2:$M$2,0)))

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[yogia]

Sorry ... I misunderstood the question.

Go with Skip's solution with the following edited version ...

=SUMPRODUCT((B2:M2=A1)*(A3:A68=B1)*(B3:M68))

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com