Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
I need help with the formula.
A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
If the only possible options are Mar and May then:
=IF(K2="Mar",SUM(A2:AC2),SUM(A2:E2)) If K2 can have any month, then you would need something with the MATCH function -- Gary''s Student - gsnu200748 "Lisa" wrote: I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
=SUM(A2:INDIRECT(ADDRESS(2,MATCH(K2,A1:E1,0),4,1)) )
If you have all months, adjust ranges! Regards, Stefi €˛Lisa€¯ ezt Ć*rta: I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
=SUM(A5:OFFSET(A2,0,MATCH(k2,1:1,0)-1))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
This formula returns an empty cell if K2 is not Mar or May. If you want it
to return 0, change the "" to 0 =IF(K2="Mar", SUM(A2:C2),if(K2="May",SUM(A2:E2),"")) "Lisa" wrote in message ... I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Not an IF formula, but try =SUM(OFFSET(A2,0,0,1,MATCH(K2,A1:E1,1)))
-- David Biddulph "Lisa" wrote in message ... I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
That worked! Thank you Stefi.
"Stefi" wrote: =SUM(A2:INDIRECT(ADDRESS(2,MATCH(K2,A1:E1,0),4,1)) ) If you have all months, adjust ranges! Regards, Stefi €˛Lisa€¯ ezt Ć*rta: I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
This one worked. That you!
"Don Guillett" wrote: =SUM(A2:OFFSET(A2,0,MATCH(k2,1:1,0)-1)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... =SUM(A5:OFFSET(A2,0,MATCH(k2,1:1,0)-1)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... This one worked. That you! "Don Guillett" wrote: =SUM(A2:OFFSET(A2,0,MATCH(k2,1:1,0)-1)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... =SUM(A5:OFFSET(A2,0,MATCH(k2,1:1,0)-1)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Thank you!
"Don Guillett" wrote: =SUM(A2:OFFSET(A2,0,MATCH(k2,1:1,0)-1)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... =SUM(A5:OFFSET(A2,0,MATCH(k2,1:1,0)-1)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Lisa" wrote in message ... I need help with the formula. A B C D E 1 Jan Feb Mar Apr May 2 10 5 15 7 8 If K2 is Mar I need to sum A2 thru C2. If K2 is May I need to sum A2 thru E2. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|