Sum in a Column

[AnnieGr]

This one hopefully is my last one. I need Excel to look up a region, and then the type of job which I have done. Then the final column I need it to total the number of hours. So my CountIFS bit works, but as soon as I add the formula to total the hours up from I11 to I164 it just wont work. If I take the sum bit out works and gives me the number of restoration jobs

=COUNTIFS('[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$A$11:$A$164, "02-TYNE AND WEAR", '[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$B$11:$B$164, "RESTORATION", '[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!SUM($I$11:$I$164))

In other words how many hours have been accumulated in the Tyne and Wear Area, that are restoration jobs?

Ugh.....

 

[gaz_chops]

Look at sumifs

Similar to countifs

=SUMIFS('[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$I$11:$I$164,'[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$A$11:$A$164, "02-TYNE AND WEAR", '[Generator Daily Data 19.01.2019.xlsx]SUPPLIER TEMPLATE'!$B$11:$B$164, "RESTORATION")

 

[steve the fish]

You need sumifs not countifs if you want to sum.

 

[AnnieGr]

Ah right so I had this the wrong way round. I thought it had to look at the columns and rows and then do the calculation. Thank you

 

[gaz_chops]

Yea same as countifs, but add the column range to sum 1st.