Formula Question

  • Thread starter Thread starter whiteviperx
  • Start date Start date
W

whiteviperx

Can you create a formula that looks for text in a column and adds the
total up of each row the text is on. Column B has Names. Column P has
values.
 
Kind of a subtotal based on Name?

If yes, then sort your data by name and do Data|Subtotals.

When you get real adventurous, try Data|Pivottable...)
 
One way, using SUMIF

Assuming data starts in row2 down
and you have say, a unique list of the names in Q2 down

Put in say, R2: =SUMIF(B:B,Q2,P:P)

Copy R2 down as many rows
as you have unique names listed in col Q
 
Back
Top