Totaling Cells with Like Information
=SUMIF(A:A,200,B:B)
OR
=SUMIF(A:A,<ReferenceCell,B:B)
If this post helps click Yes
---------------
Jacob Skaria
"LaDonna Brooks" wrote:
Is there a formula where you could do the following:
1A 200, 1B 25,000
2A 201, 2B 30,000
3A 202, 3B 10,000
4A 200, 4B 15,000
5A 201, 5B 5,000
6A 200, 5B 12,000
Can you have it total everything in Cell A with like codes? Is there a way
if the codes are the same in CellA €“ could it add 1A (25,000), 4A (15,000),
6A (12,000)? Thanks,
--
msladona
|