How to Calculate something

[Markus]

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

 

[Gary''s Student]

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

 

[Sandy Mann]

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.

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk