# Excel help anyone? SUMIF formula specifically. **URL:** \ **Category:** Shift518 Off Topic\ **Created:** [December 21, 2009, 7:11am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244 "2009-12-21T07:11:43Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![bennyfizzle](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/bennyfizzle/32/6291_2.png) [@bennyfizzle](https://forums.speedlife.net/u/bennyfizzle)\ **Post date:** [December 21, 2009, 7:11am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/1 "2009-12-21T07:11:43Z")
I’m trying to calculate minutes usage to a specific phone number, so I downloaded my bill as a spreadsheet. There is a column for the numbers I’ve called obviously and a call length column. Now, the phone numbers are in column C, length in column H. What would be the formula get the value in my formula column to show either the call length’s value (say, 3 minutes) only if the value of the phone number matches the number I want to filter, otherwise displaying a zero. I’ve tried =sumif(c1=“518-xxx-xxxx”),h1+0,“0”) but that doesn’t work at all :rofl little help? I realize this would be way easier in a db, but i only have a spreadsheet/excel to work with. ---
**Author:** ![Ilya](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilya/32/6404_2.png) [@Ilya](https://forums.speedlife.net/u/Ilya)\ **Post date:** [December 21, 2009, 7:12am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/2 "2009-12-21T07:12:49Z")
Give me a couple of values Benny and I’ll get the formula for you. You can put random numbers in for the phone. ---
**Author:** ![bennyfizzle](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/bennyfizzle/32/6291_2.png) [@bennyfizzle](https://forums.speedlife.net/u/bennyfizzle)\ **Post date:** [December 21, 2009, 7:19am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/3 "2009-12-21T07:19:04Z")
in the columns the numbers show up in typical phone number format, and the call length shows up as just regular old number values. sooo phone number =518-555-5555 call length=3 ? ---
**Author:** ![Ilya](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilya/32/6404_2.png) [@Ilya](https://forums.speedlife.net/u/Ilya)\ **Post date:** [December 21, 2009, 7:23am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/4 "2009-12-21T07:23:13Z")
Okay. I just put a bunch of random shit into a spreadsheet. What exactly are you looking for again? To sort by telephone number and see the total number of minutes spent on the phone with that number? ---
**Author:** ![Ilya](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilya/32/6404_2.png) [@Ilya](https://forums.speedlife.net/u/Ilya)\ **Post date:** [December 21, 2009, 7:42am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/5 "2009-12-21T07:42:19Z")
Is this what you wanted? (click cells to see formula). The number match up, so it’s working? ---
**Author:** ![bennyfizzle](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/bennyfizzle/32/6291_2.png) [@bennyfizzle](https://forums.speedlife.net/u/bennyfizzle)\ **Post date:** [December 21, 2009, 7:50am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/6 "2009-12-21T07:50:34Z")
worked like a charm, thanks man. ---
**Author:** ![Ilya](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilya/32/6404_2.png) [@Ilya](https://forums.speedlife.net/u/Ilya)\ **Post date:** [December 21, 2009, 7:51am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/7 "2009-12-21T07:51:48Z")
You’re welcome. If you need help understanding the formula, which I don’t think you do, let me know. ---
**Author:** ![ninety1two40](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ninety1two40/32/6332_2.png) [@ninety1two40](https://forums.speedlife.net/u/ninety1two40)\ **Post date:** [December 21, 2009, 8:15am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/8 "2009-12-21T08:15:20Z")
You can filter the columns as well. ---
**Author:** ![bennyfizzle](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/bennyfizzle/32/6291_2.png) [@bennyfizzle](https://forums.speedlife.net/u/bennyfizzle)\ **Post date:** [December 21, 2009, 8:16am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/9 "2009-12-21T08:16:58Z")
FILTER NOT SORT FUCK that’s what i was trying to think of. ---
**Author:** ![Ilya](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilya/32/6404_2.png) [@Ilya](https://forums.speedlife.net/u/Ilya)\ **Post date:** [December 21, 2009, 8:20am UTC](https://forums.speedlife.net/t/excel-help-anyone-sumif-formula-specifically/249244/10 "2009-12-21T08:20:54Z")
You can sort it and then do the SUM function. Or do sumif like I did above. Either way would work.