Tks it is solved
Tks it is solved
Last edited by alcalina; 03-23-2015 at 06:04 PM. Reason: Solved
removed....
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
=SUMPRODUCT(($B$2:$B$1493="PRÉ")*($A$2:$A$1493=A2)*($C$2:$C$1493))
Try that in your E column. Copy it to E2, then copy/paste down the row.
It is NOT an array formula (so just press enter instead of cntrl+****+enter)
Tks!!!! It worked like a charm!!!!
Array formula (Ctrl+Shift+Enter)
Formula:![]()
=IF(B2="PRÉ";SUM(($B$2:$B$1493="PRÉ")*($A$2:$A$1493=A2)*$C$2:$C$1493);"")
And is not Array
Formula:![]()
=IF(B2="PRÉ";SUMPRODUCT(($B$2:$B$1493="PRÉ")*($A$2:$A$1493=A2)*$C$2:$C$1493);"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks