Counting Items within a VLOOKUP

[dharmalife87]

This has 2 items involved: A count function and a Sum function within a VLOOKUP. Though I may be incorrect in my assumption of them being within the VLOOKUP

I need to Count the number of times the word "Total" comes up within a specific chart

After that and in a different cell I need to pull up the amounts associated with those "total"'s and sum them up

 

[asad]

You don't need vlookup for any of the above.
The countif formula will give you the first answer and either sumif or sumproduct will give you the second answer.

 

[Michael M]

Try

Excel 2010
	A	B
1	Data	1
2	Data	2
3	Total	3
4	Data	4
5	Data	5
6	Total	6
7	Data	7
8	Total	8
9	Data	9
10	Data	5
11
12	Count of Total	3
13	Sum of Total	17
14
Sheet1

Cell Formulas
Range	Formula
B12	=COUNTIF(A1:A10,"Total")
B13	=SUMIF(A1:A10,"Total",B1:B10)