Sumif using VALUE() in sum range

A

azidrane

Hey, I need to write a formula that does a sumif with the sumrange
being in text. lets say i have this:

3377 work 00:01:16
3377 work 00:03:16
3377 work 00:01:16
3377 work 00:01:17
3377 work 00:01:16
7733 work 00:01:16
7733 work 00:01:26
7733 work 00:01:13
7733 work 00:01:16
7733 work 00:01:16



When i do =sum(Value(C1:C10)) on this range, i get a result.
when i do =sumif(A1:A10,"3377",Value(C1:C10)), it won't even let me do
this.

clues?
 
B

Bob Phillips

Don't bother with it
=sumif(A1:A10,"3377",C1:C10)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
A

azidrane

Don't bother with it
=sumif(A1:A10,"3377",C1:C10)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...

You see, since the C column is actually just text, it won't work that
way. This is the problem.
 
H

Harlan Grove

azidrane said:
You see, since the C column is actually just text, it won't work that
way. This is the problem.
Click to expand...

Fine, so use

=SUMPRODUCT((A1:A10&""="3377")*C1:C10)

SUMIF's 1st and 3rd arguments must be range references. VALUE(C1:C10)
is an array, not a range reference. That's why you get a syntax error
with =SUMIF(A1:A10,"3377",VALUE(C1:C10)).
 
Top