View Single Post
  #1   Report Post  
bruno
 
Posts: n/a
Default How to : SUM - IF formula

Can anybody help me out here ?=20

Maybe a little example to explain a bit ...
Let's say I have the following data :

=B0=B0=B0=B0=B0A=B0=B0=B0=B0=B0=B0=B0=B0=B0=B0B=B0 =B0=B0=B0=B0=B0=B0=B0=B0=
=B0C=B0=B0=B0=B0=B0=B0=B0=B0=B0=B0D
1 =B0=B0Bruno______V________PMV=20
2 =B0=B0Jane______AMV________V_______ PMV
3 =B0=B0Bruno_______________AMV
4 =B0=B0Jane____AMV+PMEx_____V________V
5 =B0=B0Jane_____V

I now want to count the times that, with Jane in the A=20
column,=20
I have V or AMV or PMV in the whole cell or part of the=20
cell.

So for Jane, it would be=20
4 times V =3D 4 times 1 =3D 4
3 times (AMV or PMV) =3D 3 times 0.5 =3D 1.5

Thanks for your assistance !!