How to Calculate something

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Markus - 18 Apr 2008 14:30 GMT

Hi i hope some one can give me a hand i have this example in excel where i
have the month in this example its Apr and then i have the table below it and
what i want is it to calculate where is the Apr is right up to Jan I thought
i could do it with the SUMIF but it does not really want to work maybe some
one else has an idea

Apr



    Jan        1912
    Feb        1997
    Mar        1619
    Apr    722
    May        687
    Jun        1084
    Jul        346
    Aug        1002
    Sep        1030
    Oct        1011
    Nov        958
    Dec        847
    Jan        783
    Feb        785

Reply to this Message

Gary''s Student - 18 Apr 2008 15:41 GMT

Say your data is in columns A & B. In C1 we have:
Apr

In D1 enter:
=SUM(B1:INDIRECT("B" & MATCH(C1,A1:A100,0)))
this displays 6258

Signature

Gary''s Student - gsnu200780

> Hi i hope some one can give me a hand i have this example in excel where i
> have the month in this example its Apr and then i have the table below it and
[quoted text clipped - 20 lines]
> Jan 783
> Feb 785

Reply to this Message

Sandy Mann - 18 Apr 2008 16:18 GMT

Or without the volatile INDIRECT() function:

=SUM(B1:INDEX(B1:B14,MATCH(C1,A1:A14,0)))

But I get 6250, I assume that the 8 was a typo.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Say your data is in columns A & B. In C1 we have:
> Apr
[quoted text clipped - 29 lines]
>> Jan 783
>> Feb 785

Reply to this Message

Rate this thread: