I have a spreadsheet with a unique key for a customer in column A, and then I have the data by month in columns B-D. Some customers have multiple lines, so I have used a sumif to sum for that customer. My question is this: I would like to know if there is a way to write a formula such that the value returned is the sum of all three columns (B-D) so I would see the total for a customer for the quarter. I can get around this by writing three sumif formulas, but I figure there must be an easier, simpler, way.
Formula To Sum Three Columns
-
-
-
Re: Formula To Sum Three Columns
Just use the range B:D in your SUMIF. Or attach a sample workbook for more help.
-
Re: Formula To Sum Three Columns
[COLOR="Blue"]=SUMPRODUCT( (A1:A10 = "Customer A") * B1:D10 )[/COLOR]
-
Re: Formula To Sum Three Columns
how about
=SUMPRODUCT((A1:A100="customername")*(B100:D100))
-
Re: Formula To Sum Three Columns
TK, that will sum B100:D100 for each instance of customername.
-
-
Re: Formula To Sum Three Columns
mmmmm - don't think so shg...
...but if there is no additional array, then the parenthesis are probabaly unnecessary.
-
Re: Formula To Sum Three Columns
Thanks, that was most helpful, I appreciate your time!
-
Re: Formula To Sum Three Columns
Todkerr, I think you meant:
=SUMPRODUCT((A1:A100="customername")*(B1:D100))
kwgriffi, Please say which member you are replying to.
-
Re: Formula To Sum Three Columns
Yep - quite right Cringe (AND SHG!)
I Reding and tping toooo fst tday. LOL!
-
Re: Formula To Sum Three Columns
No problem -- yet get more than you miss.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!