About Us

[email protected]

On Sunday, December 2, 2012 4:26:08 PM UTC+2, plinius wrote:
Il 02/12/2012 14:01, ha scritto:

Thanks for the reply but this only finds it once. This is the table

A B C D

1456 1457 Bronze

1457 1456 Silver

1458 1456 Silver

1459 1457 Bronze

1460 1465 Bronze

1461 1456 Bronze

1462 1457 Silver

1463 1454 Silver

1464 1457 Silver

1465 1454 Silver

1466 1465 Bronze

1467 1464 Silver

1468 1457 Silver

As you can see in column D next to reference number 1456 I need to check wherever the number 1456 appears , then check if it is in a row which is Bronze or Silver and sum the value of either 10 or 20. I suspect this is an array formula. This formula then needs to be copied down the whole column D

I misunderstood all :-(

1456 1457 Bronze 50

1457 1456 Silver 80

1458 1456 Silver 0

1459 1457 Bronze 0

1460 1465 Bronze 0

1461 1456 Bronze 0

1462 1457 Silver 0

1463 1454 Silver 0

1464 1457 Silver 20

1465 1454 Silver 20

1466 1465 Bronze 0

1467 1464 Silver 0

1468 1457 Silver 0

If you need in column D that value, try this:

=SUMPRODUCT(($B$1:$B$13=A1)*(($C$1:$C$13="silver") *20+($C$1:$C$13="bronze")*10))

Hi

E.

Thank you, This works perfectly

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate percentage between number of exams total missed exams	ANYX	Excel Discussion (Misc queries)	3	March 18th 09 03:56 PM
calculate total number of items that meet 2 over multiple sheets	twototango	Excel Worksheet Functions	5	May 29th 08 07:04 PM
Can I total only a % of a number (cell) base on total of all cel	Douglas	Excel Discussion (Misc queries)	2	October 6th 06 09:52 PM
calculate count on 2006 total, 2005 total, etc...	Amanda Deshotel	Excel Worksheet Functions	6	September 28th 06 11:59 PM
HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER?	AMANDA RILEY	Excel Worksheet Functions	4	April 27th 06 01:00 AM

Menu

About Us