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.

 

[bbott]

Try taking out the equals sign.

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

 

[Momentman]

When you say, its not working? Do you mean returning a wrong answer or an Error?

 

[PHIL.Pearce84]

Basically, the total of the sumif should be 1000, and O8 has a value of 1000 in in, so intheory if I divide one by the other and times by 100 I should get 100%, but it keeps returning 0?

 

[PHIL.Pearce84]

ADVERTISEMENT

Thank you, I tried but to no avail i'm afraid

 

[Momentman]

I doubt if removing the equal sign will change the outcome

But for the SUMIF to work, you have to be certain that "Paving & Roadways" as written in the formula is exactly as it appears in the data

 

[PHIL.Pearce84]

ADVERTISEMENT

I did tried just replacing this with a numeric values but still didn't work, I am well and truly lost

 

[Momentman]

If it evaluates to 0 or "", then the IF is probably evaluating to false, what are the values of B3 and Breakdown!B8? you can use the formula auditor to see what is really happening

 

[PHIL.Pearce84]

2, these cells are esentially unique reference numbers so I type 2 into both for testing

 

[Momentman]

Have you checked that your calculation option for the worksheet/workbook is automatic and not manual?