Averageifs - syntax issues

[mattharesign]

Hi

I'm trying to use averageifs to average sone values based on certain criteria.

I need to take data in column c away from column s, then average the result for the entire range. Cells in column s may be blank though. For the entire set of columns with no other criteria, I get the correct result

with =average(if(isnumber S2:s3000),S2:s3000-c2:c3000) finsihed off with ctrl shift enter.

What I need to do is check data in column e, and do the same calculation again, but only for that specific result.

eg, column e contains a data type "callback", so i only need the calculation done for the cells in s and c that have this in cell e.

I keep getting errors of various flavours and I'm not sure why.

Help?

 

[Chris Mack]

=AVERAGE(IF(ISNUMBER(S2:S3000),IF(E2:E3000="callback",S2:S3000-C2:C3000)))

Does this work?

Chris

 

[mattharesign]

I'll try it when I get into work - thanks for the help

 

[mattharesign]

=AVERAGE(IF(ISNUMBER(S2:S3000),IF(E2:E3000="callback",S2:S3000-C2:C3000)))

Does this work?

Chris

i take it this would work if i substituted ="callback" with =x4, which contains the word "calback"?

Matt

 

[Chris Mack]

Yup.