Table Lookup

[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

 

[Frank Kabel]

Hi
try for example
=COUNTIF(A:A,17)

 

[Ken Wright]

=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)

 

[Frank Kabel]

Forgot your second question (summing)
use
=SUMIF(A:A,17,C:C)