Stuck with a SUMIF formula - Adding Column B based on Column A criteria.

[jaywizz]

OK so I have:
* column A which defines unit type
* column B which defines 2 criteria (OPEX or CAPEX)
* column C and onwards represents each calendar month and each line defines the amount of money that was spent

I want to be able to record the total amount for each type of spend each month:

i.e.

A B C
Unit Type November
Paint Capex $50.25
Sand Capex $25.50
Staff Opex $80.00
Summary Capex $75.75
Summary Opex $80.00



I can't seem to get the formula to work.

 

[wideboydixon]

Summary Capex:

=SUMIF(B2:B4,"Capex",C2:C4)

WBD

 

[reberryjr]

Two other options:
1. Create a pivot table that auto calculates the sums for you.
2. Create a dynamic range for the Type and Month columns, so that you don't have to continuously update the range.