Sum Column Based on Cell Value?
I will be trying to feature one involving multiple content of data dependant on the benefit of you cell.As an example A1 for you to A10, B1 to help B10, C1 to help C10, D1 that will D10 plus E1 that will E10 many have numeric data and I want to add one of many columns associated with data dependant on the cost of F1 along with place the outcome in F2.
Does anyone know is there a best solution to do this
If you signify type data you have on F1 I could truthfully give an individual a fine detail answer
I here’s just if you do numbers similar to 1, TWO, 3…on F1 plus my answer is founded on that
look at F2 and also type the following
=IF(F1=1, SUM(A1:A10), IF(F1=2, SUM(B1:B1
Remember I only offered you a reply for Colum YOUR and B and you need to do for your remaining portion of the Columns just like.I hope this allows…
Leave a Reply
You must be logged in to post a comment.