Just got a small question
I want to use an array plus some match-up to get the total sum (in column) for cases in column A that also exist in column C. In this example, DEF and XYZ exist in column C. So the total sum is 2+3=5.
image001.png
Just got a small question
I want to use an array plus some match-up to get the total sum (in column) for cases in column A that also exist in column C. In this example, DEF and XYZ exist in column C. So the total sum is 2+3=5.
image001.png
In D1 enter:
=IF(COUNTIF($C$1:$C$1000,A1)>0,B1,"") and copy down and then use:
=SUM(D:D)
Gary's Student
Thanks for the formula. Can we have one single formula in a cell to get the result?
Use this array formula:
Confirm as an array with Ctrl-Shift-Enter.Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Thanks, ConneXionLost. This is really nice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks