Forum Discussion
Solved
Formula for conditional sum for distinct values
I have 3 columns in a table - From, To, and Amount. From and To field contains names. The logic is if a name features in the From section, it would mean money is paid by that person and if the name f...
- =SUMIF(B2:B5, A1, C2:C5)
Thanks for your reply.
But John is hard-coded in the formula. Is there anyway where the name could be dynamic?
But John is hard-coded in the formula. Is there anyway where the name could be dynamic?
=SUMIF(B2:B5, A1, C2:C5)
- Got it, thanks a lot
- I am pleased that this suggested solution has helped you.
We wish you much success and fun with Excel.