Sum with multiple dates

[igbaria]

Hi people. Thanks again for the help.

I'm facing a new problem with a very large sheet. In fact, I want to sum the column "Extension" when a couple of criterias is true, The example:

Place Extension Date1 Date2 Date3 Date4 ............. Date21
A 3,00 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
A 2,00 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
A 3,50 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
B 4,80 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
B 2,50 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
B 3,30 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
C 5,15 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
C 2,75 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
C 2,25 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
.
.
.
.
Z 3,25 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
Z 2,50 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021
Z 4,55 12/01/2005 06/15/2005 11/22/2005 04/23/2006 09/14/2021


And, I want this results:

Place 2005 2006 2007 2008 2009 2010............2021
A Sum Ext Sum Ext Sum Ext Sum Ext......................................Sum Ext
B .............................................................................................................
C .................................................................................................Sum ext
.
.
.
Z Sum Ext Sum Ext ................................................................... Sum Ext


Can any one help me to solve this?

Thanks

 

[Zincere]

=SUM(IF((A1:A10=1)*(B1:B10=2)*(C1:C10=3),D1:D10,0)) 'Suppose D1:D10 is what you want to be summed.

Whereas 1 = 1st Criteria, 2 = 2nd Criteria, 3= 3rd Criteria

And Press Ctrl+Shift+Enter not just Enter.

 

[Aladin Akyurek]

Row\Col	A​	B​	C​	D​	E​	H​	I​	J​
1​	Place	Extension	Date1	Date2	Date3	Place	2005​	2006​
2​	A	3​	12/1/2005​	6/15/2005​	11/22/2005​	A	25.5​	0​
3​	A	2​	12/1/2005​	6/15/2005​	11/22/2005​	B	28.5​	0​
4​	A	3.5​	12/1/2005​	6/15/2005​	11/22/2005​
5​	B	4.8​	12/1/2005​	6/15/2005​	11/22/2005​
6​	B	2.5​	12/1/2005​	6/15/2005​	11/22/2005​
7​	B	3.3​	12/1/2005​	6/15/2005​

In I2 control+shift+enter, not just enter, copy across, and down:

<strike></strike>=SUM(IF($A$2:$A$7=$H2,IF(YEAR($C$2:$E$7)=I$1,$B$2:$B$7)))

 

[igbaria]

I knew it was simple. Shame on me.......