sumproduct help appreciated

[chef]

Hi
i have a worksheet called master

ColA
Access
Access
Medicine
etc

Col B
Medical
Medical
Admin
Admin etc

Col C
Band 1
Band 2
Band 2
etc

Col D
1.0
0.5
etc

In a sheet called Access and in cell C27 I am trying to sum the total of ColD if A27=Access and if A41 = Admin and if C26 = Band 2.

been trying with sumproduct but cant seem to get my head around.

would appreciate any help if this is possible to do

many thanks....

 

[Aladin Akyurek]

Access, C27

=SUMPRODUCT(--(Master!$A$2:$A$100=A27),--(Master!$B$2:$B$100=A41),--(Master!$C$2:$C$100=C26),Master!$D$2:$D$27)

 

[chef]

aladin

brilliant !!!!!!

you have no idea how much this is going to help save a lot of work

many many thanks

 

[Aladin Akyurek]

aladin

brilliant !!!!!!

you have no idea how much this is going to help save a lot of work

many many thanks

You are welcome. Thanks for providing feedback.