Report: Count of one field if another is a certain value problem!

Hi,

I have a data report with say 5 columns of data fields A- E.



There are 6 rows of data.



A___B___C ___D ___E

1__ MS__ ___ 5__10

2 __XX__0___20___5

3 __MS__0___0 ___20

4__ XX__0___20___5

5 __MS__ ___15___10

6__ MS__0___20___5



I want to be able to have a count under each field column C, D and E but only count the number on entries for each where the field B is 'MS' and not XX.



I've been trying to combine Count and iif statements but I'm getting in a complete mess...can anyone uggest a formula I can use for the report please?!



Much appreciated in advance,

Pusscat.

Report: Count of one field if another is a certain value problem!