Hi,
I am looking for a formula that will consider: if column A shows a particular number and column D shows a particular name and column E indicates "Credit" or "Credit & Mobile Buying" then multiply the values in columns F and G. And then the sum total of the multiplications of the all the rows in which this was true.
I have attached an excel with a table below to indicate how the values should come out.
I would prefer not to use a helper column.
Any help much appreciated.
Leo
Something like this? Paste into B16 and drag across/down:
Confirm as an array formula with CSE.
Please Login or Register to view this content.
Last edited by mcmahobt; 03-13-2015 at 01:54 PM. Reason: Entered as array
Spread the love, add to the Rep
"None of us are as smart as all of us."
Something like this? Paste into B16 and drag across/down:
Confirm as an array formula with CSE.Please Login or Register to view this content.
Last edited by mcmahobt; 03-13-2015 at 01:54 PM. Reason: Entered as array
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks