Countif or Sumif

[philb99]

Need some help please

I have a tab with quite a few columns and need totals

Col A = Staff Names
Col B = Course Name
Col C = whether they have Pass or Fail
Col D = uk or non uk

i wish to creat a new tab and count how many staff have pass or fail and if they sit in Uk or non uk

New tab with reference to first tab
Col A = course Name
Col B + Col C = fail uk and fail non uk Totals
Col D + Col E = pass uk and pass non uk Totals

thanks

 

[philb99]

Brilliant - works perfectly - thank you so much