Table Lookup

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi, I have a table that I need to search for data.

I am trying to count the number of invoices (Column B) a
particular tech has (column A:A)

And trying to sum the dollar values a techs invoices equal.

How do I do this?


Ex.
Table A.

Tech Invoice# Invoice Amount
17 5555 2.32
18 5556 1.31
17 5557 5.62


Thanks


Todd
 
=SUMIF(A:A,"TechName",B:B)

You can replace TechName with a reference and put the name in the reference

=SUMIF(A:A,D1,B:B)
 
Back
Top