• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do i calculate using varying criteria?

Rachael000

New Member
Hi there... new to this, but i have an excel question that no-one seems to have an answer for and i'm hoping you can help?


I've got a large spreadsheet, containing information on project leads i'm chasing, for two separate offices. I differentiate between the two offices in column A by noting either 'X' or 'T' on each row.


I also have the project value in column C, noted as 1.7, 0.56 etc.


What i want to do is put in a formula which calculates the project totals for each office... for example: if column A (A2:A273) ="T", then add the corresponding value in column C to the final number. If A2:A273="X" then ignore the corresponding value in column C for that row.


I need to have two separate project totals for office 'X' and office 'T', but i can't figure out how to do it.


Would rather not write a macro as i've never done it before, but if you could show me a way to write a formula to work out the above i'd be very grateful!


Thanks :)


Rachael.
 
You can use sumif formula to do this.


total for project "X" =sumif(A2:A273,"X",C2:C273)

total for project "T" =sumif(A2:A273,"T",C2:C273)
 
Back
Top