Forum Discussion
enter formula that counts and sums total for an individual
Hello I am trying to calculate a formula that counts a person's name and will calculate sum totals for that individual. But each item is located in a different column. Name is on one column, 2 ...
=SUMPRODUCT(($A$2:$A$10=A13)*$B$2:$C$10)You can try this formula for the data layout of the example.
Thank you I will try it now to see if it works! I appreciate your quick response.
Andrea
Andrea