Hi All,
I have a situation in which based on a condition I need to get total from multiple columns. Below showing sample data:
Column-A Column-B Column-C Column-D
Person1 5000 10000 15000
Person2 5000 5000 10000
Person2 4500 20000 15000
Person3 12000 15000 10000
Person1 1000 8000 7000
If I apply formula =sumif(A2:A6,"Person1",B2:D6) it is not giving correct output i.e it is totaling values in column-B only. However if I apply an array formula =sum(if(A2:A6,"Person1",B2:D6)) I get the correct total.
My problem is that I am unable to understand why simple SumIf is not working.
Thanks,
Dheeraj
I have a situation in which based on a condition I need to get total from multiple columns. Below showing sample data:
Column-A Column-B Column-C Column-D
Person1 5000 10000 15000
Person2 5000 5000 10000
Person2 4500 20000 15000
Person3 12000 15000 10000
Person1 1000 8000 7000
If I apply formula =sumif(A2:A6,"Person1",B2:D6) it is not giving correct output i.e it is totaling values in column-B only. However if I apply an array formula =sum(if(A2:A6,"Person1",B2:D6)) I get the correct total.
My problem is that I am unable to understand why simple SumIf is not working.
Thanks,
Dheeraj