How To Add an "Unless"

[burntheland]

I'm working on a spreadsheet for work. I have three columns I'm working with. One has names, the second has hours worked, and the third has the account it would come out of. I need the formula to add the hours worked if the names in the first column are the same, but it needs to not add the hours to the total if the third column says "CT".

Here's an example of what I'm looking for:

=SUMIF(A:A,"BIGGS",E:E)UNLESS(G:G="CT")

I've had minimal training with Excel and I'm doing the best I can, but I definitely need help.

Thank you!

 

[Eric W]

Try:

=SUMIFS(E:E,A:A,"BIGGS",G:G,"<>CT")

 

[burntheland]

IT WORKED! Thank you! You're a lifesaver, Eric!

 

[Eric W]

Glad to help, and welcome to the Board!

 

[burntheland]

Thanks! I imagine this place is gonna be my new best friend.

I have another question relating to this. Is there a way to get the system to subtract the hours in the total if the account column says "CT"?

 

[Eric W]

Possibly:

=SUMIFS(E:E,A:A,"BIGGS",G:G,"<>CT")-SUMIFS(E:E,A:A,"BIGGS",G:G,"CT")

 

[burntheland]

Well, now I feel silly for asking. That's so simple! Thank you, again!