Formula Question

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.
 
D

Dave Peterson

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...)
 
M

Max

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
 
Top