Formula for Quantity & plus the Amount

**rana19** · 10-09-2015, 06:51 AM

R/Sir
i use this formula =SUMPRODUCT(SUMIFS(INDEX('PRICE LIST'!C3:V3,MATCH(B3,'PRICE LIST'!B3,0),),'PRICE LIST'!C2:V2,D3:V3)*(D5:V5)) in purchase sheet Z5 to Z14 columns than i am add the Quintity in D5 to V5 Columns & add the Amount in extra column in W5 this extra amount was not count in total columns please resolve this sir than i am add quintity in d5 to v5 column And add the amount in extra column in W5 the extra amount in W5 Coumn was plus in total amount Z5 Columns Sir thanking you sir i am send the attachments sir & please correct this formula sir

**rana19** · 10-10-2015, 12:51 AM

r/sir
please reply sir & correct this formula sir thanking you sir

**mangesh.mehendale** · 10-10-2015, 01:09 AM

What is the rate for Extra??? In price list sheet rate for Extra is 0

**rana19** · 10-10-2015, 01:42 AM

R/sir
Delete extra rate Column in price list, in purchase sheet only i am add the Quintity in D5 to V5 Columns & add the Amount in extra column in W5 this in d5 to v5 item price & extra amount was count in total columns sir thanking you sir

**mangesh.mehendale** · 10-10-2015, 02:29 AM

Very simple then...
Also note I frozen your criteria ranges with $ so that it will easy to copy paste...

Formula:

Please Login or Register  to view this content.

or with VBA just by Pressing "Add Purchase" Button.. No need of above complicated formula

Please change your VBA coding of txtEXTRA_Change

Please Login or Register  to view this content.

and add this line

Please Login or Register  to view this content.

see attached file

Formula for Quantity & plus the Amount

LinkBack

Thread Tools

Rate This Thread

Display

Formula for Quantity & plus the Amount

Re: Formula for Quantity & plus the Amount

Re: Formula for Quantity & plus the Amount

Re: Formula for Quantity & plus the Amount

Re: Formula for Quantity & plus the Amount

Thread Information

Users Browsing this Thread

Similar Threads

spot text as value and calculate invoice amount from quantity X text value

[SOLVED] Quantity in column D based on order amount of times the order no appears

[SOLVED] Duplicate inventory items, need total on quantity and amount

[SOLVED] quantity x amount = probably an easy one but I can't figure it out.

[SOLVED] Formula for amount owing subtract amount paid

[SOLVED] calculate price * quantity = total amount in a row of excel forml.

Formula to divide a components amount by the SUBTOTAL amount

Bookmarks

Bookmarks

Posting Permissions