Dsum based on form

[luvbite38]

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?