=((SUMPRODUCT(--(($B$1:$F$1="3")+($A2:$A34="C2")),$B2:$F34)))

1 2 3 4 5
C1 10.00 20.00 30.00
C2 10.00 20.00 30.00
C3 10.00 20.00 30.00
C4 10.00 20.00 30.00
C5 10.00 20.00 30.00
C6 10.00 20.00 30.00
C7 10.00 20.00 30.00
C8 10.00 20.00 30.00
C9 10.00 20.00 30.00
C10 10.00 20.00 30.00
Total C
S1 10.50 21.00 31.50
S2 10.50 21.00 31.50
S3 10.50 21.00 31.50
S4 10.50 21.00 31.50
S5 10.50 21.00 31.50
S6 10.50 21.00 31.50
S7 10.50 21.00 31.50
S8 10.50 21.00 31.50
S9 10.50 21.00 31.50
S10 10.50 21.00 31.50
Total S

One Horizontal and another Vertical,

The arrays need to be the same size so that won't work...

"MESTRELLA29" wrote:

=((SUMPRODUCT(--(($B$1:$F$1="3")+($A2:$A34="C2")),$B2:$F34)))

1 2 3 4 5
C1 10.00 20.00 30.00
C2 10.00 20.00 30.00
C3 10.00 20.00 30.00
C4 10.00 20.00 30.00
C5 10.00 20.00 30.00
C6 10.00 20.00 30.00
C7 10.00 20.00 30.00
C8 10.00 20.00 30.00
C9 10.00 20.00 30.00
C10 10.00 20.00 30.00
Total C
S1 10.50 21.00 31.50
S2 10.50 21.00 31.50
S3 10.50 21.00 31.50
S4 10.50 21.00 31.50
S5 10.50 21.00 31.50
S6 10.50 21.00 31.50
S7 10.50 21.00 31.50
S8 10.50 21.00 31.50
S9 10.50 21.00 31.50
S10 10.50 21.00 31.50
Total S

One Horizontal and another Vertical,

It was a Long shoot any way, any sugestions how to do this?

I need to call a given Month from a Cell, and that this will update all The
other Part No.

"Jim Thomlinson" wrote:

The arrays need to be the same size so that won't work...

"MESTRELLA29" wrote:

=((SUMPRODUCT(--(($B$1:$F$1="3")+($A2:$A34="C2")),$B2:$F34)))

1 2 3 4 5
C1 10.00 20.00 30.00
C2 10.00 20.00 30.00
C3 10.00 20.00 30.00
C4 10.00 20.00 30.00
C5 10.00 20.00 30.00
C6 10.00 20.00 30.00
C7 10.00 20.00 30.00
C8 10.00 20.00 30.00
C9 10.00 20.00 30.00
C10 10.00 20.00 30.00
Total C
S1 10.50 21.00 31.50
S2 10.50 21.00 31.50
S3 10.50 21.00 31.50
S4 10.50 21.00 31.50
S5 10.50 21.00 31.50
S6 10.50 21.00 31.50
S7 10.50 21.00 31.50
S8 10.50 21.00 31.50
S9 10.50 21.00 31.50
S10 10.50 21.00 31.50
Total S

One Horizontal and another Vertical,

I am a little lost on your question. Where are the months represented in the
table. Which are the part numbers. I am suspecting that you will wna to use
an offset function or the like but I need more details...

"MESTRELLA29" wrote:

It was a Long shoot any way, any sugestions how to do this?

I need to call a given Month from a Cell, and that this will update all The
other Part No.

"Jim Thomlinson" wrote:

The arrays need to be the same size so that won't work...

"MESTRELLA29" wrote:

=((SUMPRODUCT(--(($B$1:$F$1="3")+($A2:$A34="C2")),$B2:$F34)))

1 2 3 4 5
C1 10.00 20.00 30.00
C2 10.00 20.00 30.00
C3 10.00 20.00 30.00
C4 10.00 20.00 30.00
C5 10.00 20.00 30.00
C6 10.00 20.00 30.00
C7 10.00 20.00 30.00
C8 10.00 20.00 30.00
C9 10.00 20.00 30.00
C10 10.00 20.00 30.00
Total C
S1 10.50 21.00 31.50
S2 10.50 21.00 31.50
S3 10.50 21.00 31.50
S4 10.50 21.00 31.50
S5 10.50 21.00 31.50
S6 10.50 21.00 31.50
S7 10.50 21.00 31.50
S8 10.50 21.00 31.50
S9 10.50 21.00 31.50
S10 10.50 21.00 31.50
Total S

One Horizontal and another Vertical,