Forum Discussion
FInding a cell with a particular word in, then putting the next row's figure into a new cell
I receive bank statements which show amounts received from Paypal, Amazon and Another company in Column E over many pages, and the next column shows the amount received. I wish to not only calculat...
Hi
I noticed in your sample function provided, you are using the same range as a Criteria Range (for payment methods) and as Sum Range (for amounts)
I am attaching a sample file where I am using the function in L1 as follows:
=SUMPRODUCT(ISNUMBER(SEARCH($J$1,$E$3:$E$352))*$G$3:$G$352)
The condition is selected from a drop list as needed in cell J1.
Hope that helps
Nabil Mourad
- Nabilbourad, thank you for this, I can see from the formula you have put in the body of the text what this means and will look at the attachment regarding the drop list and give it a try. Many thanks for the time you have spent offering this help.
