What is the best solution to this excel question?

[retropete]

I was hopin i could get some help regarding a problem I'm having with an excel question. I have uploaded the excel file to make it clearer as to what i need to do.
Download Excercise 1.xlsb from Sendspace.com - send big files the easy way

I know i can filter the date and then company at a time add up the total sum, but I'm sure there is a much easier (formula) way or doing this.

Any help would be great.

thanks guys

 

[JackDanIce]

Function SUMPRODUCT can help, have a read of: Excel SUMPRODUCT formula - Syntax, Usage, Examples and Tutorial | Chandoo.org - Learn Microsoft Excel Online

 

[retropete]

Thanks for the help Jack. I had a read of the link and then further reading into SUMPRODUCT but i still can't seem to answer the question..i mean i can answer the question but it just seems as if there is a much easier more efficient way of doing it.

Still open for ideas...

Thanks guys