SumIfs Help!!

[Kyosti]

I apologize, I did a search for what I needed, but had no luck understanding what I was reading. I hope someone can help me with this.

I have a database that resembles the following:

On a seperate sheet that follows:

I need to add the values in column C if they meet the following criteria:

I need to search for a spefic rep name in the database on sheet 1 and the value in column E must be True. I have tried the following formula but only get 0 as the value returned. Please help!!!!

SUMIFS(May!T2:T10000,May!E2:E10000,A13,May!AR2:AR10000,"TRUE")

The formula above is using a database that is much bigger than what I included in the post.

Thank you

 

[AlphaFrog]

In your SUMIFS formula, don't put quotes around TRUE

SUMIFS(May!T2:T10000,May!E2:E10000,A13,May!AR2:AR10000,TRUE)

 

[Kyosti]

I actually tried that first, and it still did not reference correctly. I just did a replace on the TRUE and changed it to True and it made the formula work, but I don't know why.