formula help

  • Thread starter Thread starter Boenerge
  • Start date Start date
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
 
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
 
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
 
Hi Paul,
Thanks for the formula, please ignore my reply. The formula works fine
thank you.
Jason
 
Back
Top