I have a unit price and a quantity... I want to be able to take the sum of the extended price without having to add a column for extended price. I don't want to just hide it, either.
Example attached.
I have a unit price and a quantity... I want to be able to take the sum of the extended price without having to add a column for extended price. I don't want to just hide it, either.
Example attached.
Last edited by kellyfspringer; 07-14-2009 at 09:46 PM.
Using your posted workbook...
Try this formula:
Does that get you headed in the right direction?![]()
Please Login or Register to view this content.
Oh, I thought that I might be able to use sumproduct, but I wasn't quite sure how.
That works PERFECTLY!!! Thanks!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks