Forum Discussion
Sum range of cells based on a common value in a column
Hi there, Bit of a novice excel user here. I feel like what I'm trying to do is very possible but I'm not sure how to make it happen. I manage meeting rooms in an office tower and am tracking iss...
=SUMPRODUCT(($A$2:$A$25=G7)*$C$2:$E$25)You can try this formula for the data layout of the example.