Summing with conditions
Hi again,
Am Fri, 18 Sep 2015 09:13:00 +0200 schrieb Claus Busch:
sorry, I did not read carefully.
I forgot to set the first row absolut:
in AL3:
=IF(ISNUMBER(SEARCH("FULL",$AL$1)),SUMPRODUCT(--(YEAR(B$1:AK$1)=2015),B3:AK3),IF(RIGHT($AL$1,1) ="1",SUMPRODUCT(--(YEAR(B$1:AK$1)=2015),--(MONTH(B$1:AK$1)<=6),B3:AK3),SUMPRODUCT(--(YEAR(B$1:AK$1)=2015),--(MONTH(B$1:AK$1)6),B3:AK3)))
In AM3:
=IF(RIGHT($AM$1,1)="1",SUMPRODUCT(--(YEAR(B$1:AK$1)=2014),--(MONTH(B$1:AK$1)6),B3:AK3),IF(RIGHT($AM$1,1)="2", SUMPRODUCT(--(YEAR(B$1:AK$1)=2015),--(MONTH(B$1:AK$1)<7),B3:AK3),SUMPRODUCT(--(YEAR(B$1:AK$1)=2014),--(MONTH(B$1:AK$1)6),B3:AK3)+SUMPRODUCT(--(YEAR(B$1:AK$1)=2015),--(MONTH(B$1:AK$1)<7),B3:AK3)))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|