Vlookup and Sumif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my spreadsheet I have a named area in column T

In column X I would like the formula to look in Column W and any time that number shows up in named area in column T it would add it up. Example
T W
1 1
2 2
1 3




Any help would be greatly appreciated

Thank you!
 
Hi Cathy!

Try:
=COUNTIF($T$1:$T$100,W1)
Copy down


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Cathy said:
In my spreadsheet I have a named area in column T.

In column X I would like the formula to look in Column W and any
Click to expand...
time that number shows up in named area in column T it would add it
up. Example -
 
Back
Top