# What is the best solution to this excel question?

#### retropete

##### New Member
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### retropete

##### New Member
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

Replies
5
Views
84
Replies
2
Views
59
Replies
4
Views
71
Replies
0
Views
27
Replies
13
Views
153