Excel help anyone? SUMIF formula specifically.

Shift518 Automotive Shift518 Off Topic
1

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.

2

Give me a couple of values Benny and I’ll get the formula for you. You can put random numbers in for the phone.

3

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

?

4

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?

5

Is this what you wanted? (click cells to see formula).

The number match up, so it’s working?

6

worked like a charm, thanks man.

7

You’re welcome. If you need help understanding the formula, which I don’t think you do, let me know.

8

You can filter the columns as well.

9

FILTER NOT SORT

FUCK that’s what i was trying to think of.

10

You can sort it and then do the SUM function. Or do sumif like I did above. Either way would work.