Auto currency No. calculate

[annadinesh]

Dear Team,

I want a calculation a cell where i put the no of notes received

like

if A1 Contains the Currency Detail
and on B1 I write the qty of the NOTES received and on C1 the Calculation should Show

A1 B1 C1
100 2 200.00

then if again i received 3 NOTES then I should Write like this ( i will write 3 on B1)

A1 B1 C1
100 3 200.00

then the result automatically should shows like this

A1 B1 C1
100 5 500.00

and if i double click on B1, then it should show as =2+3

pls check



Regards
Dinesh Saha
9932022569

 

[oldbrewer]

note	quantity	total
100	3	300
200	4	800			note	total
100	5	500			100	1500
200	6	1200			200	3600
100	7	700
200	8	1600
					1500 obtained by
					=SUMPRODUCT(($A$2:$A$7=F4)*($C$2:$C$7))

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

note	quantity	total
100	3	300
200	4	800			note	total	(notes)
100	5	500			100	1500	15
200	6	1200			200	3600	18
100	7	700
200	8	1600
					1500 obtained by
					=SUMPRODUCT(($A$2:$A$7=F4)*($C$2:$C$7))
					15 obtained by
					=SUMPRODUCT(($A$2:$A$7=F4)*($B$2:$B$7))

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>