Formula Not working

[PHIL.Pearce84]

Hi, Wonder if anyone can tell me wants wrong with my formula?

=IF($B3=Breakdown!$B8,SUMIF($Q$4:$MQ$4,"=Paving & Roadways",$Q8:$MQ8)/Breakdown!O8*100,"")

I am trying to find the percentage that the contributions for "Paving & Roadways" make up of the annual total received.

I am completely lost as to why it is not working

Thanks in advance.

 

[PHIL.Pearce84]

Just checked and is on auto

 

[Momentman]

Here's my attempt and recreating your scenario

Excel 2010
	P	Q	R	S	T	U	V	W	X	Y	Z
4	100.5	Paving & Roadways	ab	Paving & Roadways	ab	Paving & Roadways	ab	ab	Paving & Roadways	ab	Paving & Roadways
5											156
6
7
8		300	270	160	286	284	244	209	140	258	156
Sheet1

Cell Formulas
Range	Formula
P4	=IF($B3=Breakdown!$B8,SUMIF($Q$4:$Z$4,"Paving & Roadways",$Q8:$Z8)/Breakdown!O8*100,"")

I used B3 as 2 and Breakdown!B8 as 2.

 

[PHIL.Pearce84]

Can't see why mine is not working, woudl you be able to take a look if I emailed it to you?