Help Lookup formula

[mulberry13]

I need to have "lookup" that will look at column "C" and if it has "TRUE" then add Column "B" "units". If it says FALSE then also add Column "B" units. I need to see how many units they actually provided but also how many units were actually "not provided".

Units Confirm yn
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 FALSE

 

[T. Valko]

I need to have "lookup" that will look at column "C" and if it has "TRUE" then add Column "B" "units". If it says FALSE then also add Column "B" units. I need to see how many units they actually provided but also how many units were actually "not provided".

Units Confirm yn
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 TRUE
4 FALSE

Maybe these...

=SUMIF(C2:C13,TRUE,B2:B13)

=SUMIF(C2:C13,FALSE,B2:B13)

 

[texasalynn]

sorry not understanding? You say the same thing for both conditions

 

[VoG]

Unclear. What results do you expect for your example?

 

[mulberry13]

yes Ty I think you have the formula I need thanks so much. I kept getting kicked out of my thread for some reason.

 

[T. Valko]

yes Ty I think you have the formula I need thanks so much. I kept getting kicked out of my thread for some reason.

You're welcome. Thanks for the feedback!

 

[mulberry13]

No thank you! This site has helped with so many things for years. I tell all my co-workers/friends about it. It's just wonderful. I hope retire before you ever decide not to proivde this anylonger.