Mulitiple Criteria Sum

[SaraWitch]

Hello all,

I have Column A with property type and Column B with totals in separate sheet. I am trying to total "Post war parlour 3 bed" and "Pre war parlour 3 bed" to give one total for 3 bed parlours. I have tried:

{=SUMIFS('Pivet Tables'!$B$3:$B$63,'Pivet Tables'!$A$3:$A$63,"Post war parlour 3 bed",'Pivet Tables'!$A$3:$A$63,"Pre war parlour 3 bed")}

but this is returning a total of '0', which is wrong (there are 100).

I can't use a wild card as there are non parlour 3 bed properties (i.e. =SUMIF('Pivet Tables'!$A$3:$A$63,"*parlour 3 bed",'Pivet Tables'!$B$3:$B$63)

Any help how to do this would be greatly appreciated!

Ta muchly, folks!

 

[jtakw]

Hi,

Try SUM your SUMIFS, regular formula, Not CSE:

Book1
	B
1	#VALUE!
Sheet31

Cell Formulas
Range	Formula
B1	=SUM(SUMIFS('Pivet Tables'!$B$3:$B$63,'Pivet Tables'!$A$3:$A$63,"Post war parlour 3 bed"),SUMIFS('Pivet Tables'!$B$3:$B$63,'Pivet Tables'!$A$3:$A$63,"Pre war parlour 3 bed"))