Hello,
I'm trying to solve this for days, with no succes.
I've attached a jpeg for making my question more clear.
In the first column (column A6:A11) I have 7 values.
In the table B6:I11there are random numbers.
If I fill in a number in cell B16.
I would like to find a formula (in cell B17) that is looking up that number in the table.
If it finds the exact number, it gives the value in the same row in column A.
If it finds the number more times, all the corresponding values in column A must add up.
I hope someone can help me with this one.
greetz,
Owen
Last edited by owenkam; 05-10-2010 at 05:24 AM.
Try
=SUM(IF(B6:I11=B16,A6:A11))
entered as an array formula (ie use Control - Shift - Enter)
whu not attach a xl workbook not an image!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you Huron,
The formula works fine!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks