Excel : how do I sum costs if the they relates to the same period

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bomby - 16 Aug 2006 16:59 GMT

I have spread sheet with a 3 columns
1. column contains the projectnumber(1,2,3 etc)
2. column contains the week
3. column contains the cost made per week and per project(manually entrie)
4 column should sum all the costs which are made in the different weeks.

I dont want to have totals per project. If the costs made for several
projects in one week, eg week 30 will appear 3 times (entry per
projectnumber) , than I want to have a total of all costs made per week. (sum
of the 3 entries )

Reply to this Message

Marcelo - 16 Aug 2006 17:21 GMT

hi

try to use sumproduct as,

=sumproduct(--(a2:a1000=project number)*(b2:b1000=Week);(c2:c1000))

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> I have spread sheet with a 3 columns
> 1. column contains the projectnumber(1,2,3 etc)
[quoted text clipped - 6 lines]
> projectnumber) , than I want to have a total of all costs made per week. (sum
> of the 3 entries )

Reply to this Message