formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Boenerge - 27 Mar 2008 22:34 GMT

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

Reply to this Message

PCLIVE - 27 Mar 2008 22:43 GMT

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

> What formula would I use to search down a column find a name and report
> the
[quoted text clipped - 4 lines]
> Thanks in advance
> Jason

Reply to this Message

Boenerge - 28 Mar 2008 22:19 GMT

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

> You can sum the corresponding cells matched without having a dedicated
> column of numbers.
[quoted text clipped - 14 lines]
> > Thanks in advance
> > Jason

Reply to this Message

PCLIVE - 28 Mar 2008 22:22 GMT

Glad to help.

> Hi Paul,
> Thanks for the formula, please ignore my reply. The formula works fine
[quoted text clipped - 21 lines]
>> > Thanks in advance
>> > Jason

Reply to this Message

Boenerge - 28 Mar 2008 22:14 GMT

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

> 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
[quoted text clipped - 3 lines]
> Thanks in advance
> Jason

Reply to this Message

Rate this thread: