SUMIF not working

[Injinia]

I have encountered this problem before and after hustling with it for while, I decided to redo the data.


I have 2 columns of data. column "A" with text, recurring in several instances A1:A150. column b has time in hrs:mins for the same range. The sumif therefore, on column "D" is to calculate the total time for unique occurrences(I have listed them down).


However, I get a result only on some of the occurrences and not all. So some give me 0 regardless of the fact that in column "B" there is a sum of several minutes or hours. What's more, when I filter these data column "A" and "B", the total sum for these unique occurrences changes also.


What is wrong with my data &/or formula?


-Injinia

 

[Jordan]

Hmmm, this may sound like a silly question, but are you sure that your references to cells A1:A150 and (I assume) B1:B150 are absolute reference?


If you could provide your workbook (or an example workbook) to the forum, I think that will give more information upon which to resolve your problem.

 

[Luke M]

to add to Jordan's comment, providing an example of your current formulas would also help, in case it's just a debugging issue.


I'm assuming the formula is:

=SUMIF(A$1:A$150,A1,D$1:D$150)

 

[Injinia]

my current formula on column D which is copied down to D12 since I have 12 unique occurrences C1:C12:


=SUMIF(A$1:A$150,C1,B$1:B$150)

 

[SirJB7]

Hi, Injinia!

I don't remember if I did before in other topics but...

Have I ever told you to consider uploading a sample file as indicated in the three green sticky topics at this forums main page? Maybe it helps other helping you.

Regards!

 

[Injinia]

https://www.dropbox.com/s/xhmujsa3t1pn352/sumif.xlsx


here is a sample file.


Regards.

 

[SirJB7]

Hi, Injinia!


Give a look at this file:

https://dl.dropbox.com/u/60558749/SUMIF%20not%20working%20-%20sumif%20%28for%20Injinia%20at%20chandoo.org%29.xlsx


Issues: blanks (trimmed) in text column; Escalator inexistent and Helb missing.


Regards!