How to use text value in cell as criteria

April 2018

How to use text value in cell as criteria


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.


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

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


Solved by rizvisa1
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 (
Excel - A formula to replace "#N/A" with 0
To prepare an Attendance Report with Excel sheet