Dear All
I have a table as attached. Could anybody help me to sum in column B with the value in Column A is "James". For one value of "James" in column A, I have three adjacent related value in B. How to "SUMIF" with range A1:A24, criteria "James", sumrange B1:B24. One "James" in column A relates to three row values in column B. For example, A1 relates to values of B1, B2, B3. And so on.
Thank you very much/
Image.png
Bookmarks