Hello,
I have attached a file here. I need a formula that will sum cross column. in the example: if the numbers are under short, then sum the total.
I hope what i say here make sense.
Thanks in advance for the help.
Hello,
I have attached a file here. I need a formula that will sum cross column. in the example: if the numbers are under short, then sum the total.
I hope what i say here make sense.
Thanks in advance for the help.
Last edited by jackson_hollon; 07-29-2016 at 10:18 PM.
SUMIF is your friend.
Copy and paste in cell A3 then drag over and down to B7.
Learn about SUMIFS here.Please Login or Register to view this content.
http://chandoo.org/wp/2010/04/20/int...umifs-formula/
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Mike,
It works perfectly. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks