If statement

[mbuk320000]

hi all im looking for a formular /vba code to complete the following

=AVERAGEIFS('Stock OUT'!$A$2:$A$3400,'Stock OUT'!$E$2:$E$3400,$E128,G128,V1)

Stock Out colum A is a date feiled
Coulm b is a number that maches Colum E but i only want this avg to be caculated if g128 = v1

hope that make sence

 

[steve the fish]

Hi probably something like the below. You may need to change the cell absolution:

=IF($G128=$V$1,AVERAGEIFS('Stock OUT'!$A$2:$A$3400,'Stock OUT'!$E$2:$E$3400,$E128),"Something Else")

 

[mbuk320000]

thank you