Hi, I have the following table that I like to use the SUMPRODUCT function,
but I can't seem to get it work
USER Jan Apr Mar May Feb Feb
A 565 76 6 876 54 54
B 65233 5 64 67 35 35
C 323 5555 5 54 1 1
D 221 6 8908 4 32 32
E 3 879 9 87 25 25
F 56 85 89 7 566 566
For user A, I want to sum the total for the month of Feb (because some months
could appear twice), so I want my answer to be (54+54) = 108. The table
above is from a pivot table and the columns could shift, so I want to make it
dynamic enough to sum it up if when the column moves.
Here's the formula I'm using
=SUMPRODUCT((A3:A9="A"),--(A3:G3="Feb"),A3:G9)
and I'm getting a #VALUE error.
Please help, thanks
but I can't seem to get it work
USER Jan Apr Mar May Feb Feb
A 565 76 6 876 54 54
B 65233 5 64 67 35 35
C 323 5555 5 54 1 1
D 221 6 8908 4 32 32
E 3 879 9 87 25 25
F 56 85 89 7 566 566
For user A, I want to sum the total for the month of Feb (because some months
could appear twice), so I want my answer to be (54+54) = 108. The table
above is from a pivot table and the columns could shift, so I want to make it
dynamic enough to sum it up if when the column moves.
Here's the formula I'm using
=SUMPRODUCT((A3:A9="A"),--(A3:G3="Feb"),A3:G9)
and I'm getting a #VALUE error.
Please help, thanks