Excel Question?

Question

My wife has hit a wall and has asked me to ask you if you can help.... here is her question....

"Ask how someone would create a formula in excel that would add a number in columnQ to a total at the bottom of that column only if there was the letter "A" in column T in the same row.  Does that make sense?  I know it can be done, but for the life of me I cannot figure out how to do it. "

Any help would be greatly appreciated.... 

Thanks,

Scott P · Accepted Answer

=IF(FIND("A",T26,1), Q44+5, 6)
Put this foumula in Q26, Q44 is the last row in Q, T26 contains string BFAGA
if there is an "A" in T26, the value of Q44 will add to 5, otherwise Q26 is 6.  The 6 can be replaced with other cell ID.  And 5 can also be replaced with another cell ID, for her needs.

C-bug · Answer

I can guess several scenarios for this.  I suspect you need an IF statement.

Please give us a tad more specific info, such as what column you want the formula in, and where the total is in the bottom of Col Q?

From reading your question, it sounds like col. Q already has a total formula to total items in that column, above where it is located?  

It sounds odd that you are wanting to increase the total at the bottom by an amt. that has already been included in the total.

OR - are you asking how to get a total for Col. Q that only adds up the values of the cells that contain the letter A in a nearby column?

HTH : )

Bert C · Answer

Use the "sumif" function.  Check Excel help for the syntax and how to use sumif.

Bert

suck-3-r · Answer

can you be more specific, like, can you give an example.. the concept of what you are trying to do is somehow vague. if for example you can give values to the involved quantities there, i bet, someone will be able to tell you how it could be done exactly.. ;)

Life after 45 · Answer

use the IF function :)

Trending News

Excel Question?

5 Answers