can SUMPRODUCT Do this
=((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, |
can SUMPRODUCT Do this
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, |
can SUMPRODUCT Do this
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, |
can SUMPRODUCT Do this
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, |
All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com