HI GUYS,
I am trying to sum four columns based on condition on the form
example
I have four columns i.e. PG in 1, PG in 2, PG in 3 and PG in 4.
and
a drop down box in form called select PG value
lets say if user selects 0001 - Apple from userform,
I want to sum $ in PG 1 to PG 4 where the value in PG in 1 to 4 is equal to left 4 (i.e. 0001) of the left 4 of the PG 1 to PG 4.
Hope it makes sense?
PG1 PG 2 PG3 PG4
0001-A 0001-A 0003-A 0001-C
0001-A 0002-A 0002-A 0002-D
0001-A 0002-A 0004-A 0001-E
$ IN PG 1 $ IN PG 2 $ IN PG 3 $ IN PG 4
1 1 1 1
1 1 1 12
1 1 1 10
USER SELECTED 0001 - A
ANSWER EXPECTED FOR ALL 0001
15
HOPE IT MAKES MORE SENSE?
I am trying to sum four columns based on condition on the form
example
I have four columns i.e. PG in 1, PG in 2, PG in 3 and PG in 4.
and
a drop down box in form called select PG value
lets say if user selects 0001 - Apple from userform,
I want to sum $ in PG 1 to PG 4 where the value in PG in 1 to 4 is equal to left 4 (i.e. 0001) of the left 4 of the PG 1 to PG 4.
Hope it makes sense?
PG1 PG 2 PG3 PG4
0001-A 0001-A 0003-A 0001-C
0001-A 0002-A 0002-A 0002-D
0001-A 0002-A 0004-A 0001-E
$ IN PG 1 $ IN PG 2 $ IN PG 3 $ IN PG 4
1 1 1 1
1 1 1 12
1 1 1 10
USER SELECTED 0001 - A
ANSWER EXPECTED FOR ALL 0001
15
HOPE IT MAKES MORE SENSE?
