User Profile
SharonMc5
Copper Contributor
Joined Sep 22, 2023
User Widgets
Recent Discussions
Re: Summing an area with one criteria on multiple rows
HansVogelaar Thank you for this explanation. I realized that the equation is returning a #value! in my spreadsheet. The only thing I can think is happening is that my spreadsheet totals are equations not actual keyed values. Is there a way to sum up the totals in the columns?1.3KViews0likes1CommentSumming an area with one criteria on multiple rows
I have a spreadsheet and trying to sum all of the rows and columns that match the criteria in the left column. I am looking for the sum of Columns F, G, H, I, J that match "1". What function can help me with this? Thanks in advance Criteria F G H I J Sum I am looking for 1 500 100 200 600 700 1 500 100 200 600 700 1 500 100 200 600 700 1 500 100 200 600 700 1 500 100 200 600 700 10,500 2 500 100 200 600 700 2 500 100 200 600 700 2 500 100 200 600 700 2 500 100 200 600 700 2 500 100 200 600 700 10,500 3 500 100 200 600 700 3 500 100 200 600 700 4,200 4 500 100 200 600 700 4 500 100 200 600 700 4 500 100 200 600 700 6,300 1 2500 This is the result I am gettingSolved1.4KViews0likes7Comments
Recent Blog Articles
No content to show