How to use text value in cell as criteria

July 2017


How to use text value in cell as criteria




Issue


In cell D1, I'm using a SUMIF formula like so

=sum if (A:A; criteria; B:B).

In Column A and B is a list of charges different companies made, the name is on A and the value of the charge is in column B. Each company has multiple charges, so their names will repeat as many times in A. So I want to sum the total charge for each company separate. So what I did is write out their names in Column C, and then what I want to do, starting from the first company in C1 is use the formula I wrote above the display the total sum for that company. But I can't figure out how to use a cell with a text value as a criteria. so for example:
=sum if (A:A; text value in C1; B:B)
I know I can write out the name of the company as the criteria, but if I do it the way I want to I can just drag the formula down the D column next to the C column, which would save time.

Solution


You can use the cell address instead of typing in the value

=SUMIF(A:A; "=" & C1; B:B)

Note


Solved by rizvisa1

Related


Published by aakai1056. Latest update on July 31, 2010 at 05:41 AM by aakai1056.
This document, titled "How to use text value in cell as criteria," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).