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

B

Bomby

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 )
 
M

Marcelo

hi

try to use sumproduct as,

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

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bomby" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up sub-headings in Excel? 1
Spread Project Costs Over Months Using Bell Curve 2
SUM in a UNION query 2
Multiple a column of costs by a single factor 5
Project: Multiplication of Costs and Constant 1
Project: Multiplication of Costs and Constant 0
how do i find the earliest entry in a table 6
Help Please 6

Top