Excel 2007 - Bi-annualy bonus pool formula

[fchachar]

Hello everyone,

I am trying to finish one of my school asignment, so far I have almost finished everything but I stuck at one point where I have to put a complex formula. I have tried all the pssible ways to figure out but my luck isnt working out. Maybe someone from you can help me finish my assignment.

http://books.google.com/books?id=WD...EwAA#v=onepage&q=bi-annual bonus pool&f=false

If you open the above link please see the item number 7. I have taken care of all the formulas but one which say 'Bi-Annual Bonus Pool'. If you look at the spreadsheet on the next page the value is '1487' It is the second last line on the left hand side. This is the value I am trying to get, can you please help me out?

Thank you kind

 

[fchachar]

Please can someone help. I will really appreciate

Thanks

 

[danzon]

I think this is what you are after

=(SUMIF(B5:B14,">10000",B5:B14)+(SUMIF(C5:C14,">10000",C5:C14)))*.03

 

[fchachar]

Thank you very very much!!!... God bless you ))))

 

[danzon]

No problem.... just an FYI... you should probably use this instead as it is a bit more simplified and removes some unnecessary references...

=(SUMIF(B5:B14,">10000")+(SUMIF(C5:C14,">10000")))*.03

 

[fchachar]

Sure will do that. Thanks once again