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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Two Formula Questions 2
newbie question 2
Excel Subtracting multiple columns from another column 3
Complicated Formula Problem 10
VLOOKUP forumla for Excel HELP! 1

Back
Top