formula help

B

Boenerge

What formula would I use to search down a column find a name and report the
number in the next column, this would be multiple times, the numbers to be
added together.
The added number reported then to be multiplied by another number and then
to be subtracted from another fixed number in a specific cell.
Thanks in advance
Jason
 
P

PCLIVE

You can sum the corresponding cells matched without having a dedicated
column of numbers.

=SUMIF(A1:A100,"Name",B1:B100)

=(SUMIF(A1:A100,"Name",B1:B100)*AnotherNumber)-SpecificCell

HTH,
Paul
 
B

Boenerge

Hi,
Thanks for the formula, however this formula doesn't report the number found
in the next column. How would I ammend the fomula to do this?
Thanks in advance
Jason
 
B

Boenerge

Hi Paul,
Thanks for the formula, please ignore my reply. The formula works fine
thank you.
Jason
 
Top