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.
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.