Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
Hi,
a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
=SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99)
HTH -- AP "Aarif" a écrit dans le message de ... Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
Hi Ardus,
Thanks for giving attention to my problem but when i am using this formula getting an value error and i am not so familier with excel formulas so dont can understand how this formula actually works, this formula looks so complecated to me,will you help me again to resolve the problem, thanks again for replying, Aarif "Ardus Petus" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99) HTH -- AP "Aarif" a écrit dans le message de ... Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
My formula is based on current row number. If row id odd, add the number,
else skip it. Do you get a #VALUE result? -- AP "Aarif" a écrit dans le message de ... Hi Ardus, Thanks for giving attention to my problem but when i am using this formula getting an value error and i am not so familier with excel formulas so dont can understand how this formula actually works, this formula looks so complecated to me,will you help me again to resolve the problem, thanks again for replying, Aarif "Ardus Petus" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99) HTH -- AP "Aarif" a écrit dans le message de ... Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
One or more of the cells in your sum range is probably producing the #VALUE!
error, which is being mirrored (returned) by Ardus' formula. Make sure there are no errors in your original data. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Aarif" wrote in message ... Hi Ardus, Thanks for giving attention to my problem but when i am using this formula getting an value error and i am not so familier with excel formulas so dont can understand how this formula actually works, this formula looks so complecated to me,will you help me again to resolve the problem, thanks again for replying, Aarif "Ardus Petus" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99) HTH -- AP "Aarif" a écrit dans le message de ... Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
I am very sorry, wested your valuable time i was discribed my problem to you
people wrongly actually i want sum of every next field. a1 a2 a3 a4 10 15 10 5 .......... I want sum of a1 & a3 skipping a2,a4........... and also want su of a2 & a4 skipping a1,a3 sorry again, i want a formula that can give me sum of every next field. thanks, Aarif "RagDyeR" wrote: One or more of the cells in your sum range is probably producing the #VALUE! error, which is being mirrored (returned) by Ardus' formula. Make sure there are no errors in your original data. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Aarif" wrote in message ... Hi Ardus, Thanks for giving attention to my problem but when i am using this formula getting an value error and i am not so familier with excel formulas so dont can understand how this formula actually works, this formula looks so complecated to me,will you help me again to resolve the problem, thanks again for replying, Aarif "Ardus Petus" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99) HTH -- AP "Aarif" a écrit dans le message de ... Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formula help
To sum even row numbers: ( A2,A4, A6,...)
=SUMPRODUCT(--(MOD(ROW(A1:A99),2)=01),A1:A99) To sum odd row numbers: (A1, A3, A5, ...) =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99) -- HTH -- AP "Aarif" a écrit dans le message de ... I am very sorry, wested your valuable time i was discribed my problem to you people wrongly actually i want sum of every next field. a1 a2 a3 a4 10 15 10 5 .......... I want sum of a1 & a3 skipping a2,a4........... and also want su of a2 & a4 skipping a1,a3 sorry again, i want a formula that can give me sum of every next field. thanks, Aarif "RagDyeR" wrote: One or more of the cells in your sum range is probably producing the #VALUE! error, which is being mirrored (returned) by Ardus' formula. Make sure there are no errors in your original data. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Aarif" wrote in message ... Hi Ardus, Thanks for giving attention to my problem but when i am using this formula getting an value error and i am not so familier with excel formulas so dont can understand how this formula actually works, this formula looks so complecated to me,will you help me again to resolve the problem, thanks again for replying, Aarif "Ardus Petus" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A99),2)=1),A1:A99) HTH -- AP "Aarif" a écrit dans le message de ... Hi, a1,a3,a5.......... =a1+a3+a5............. can i use a formula that calculate every next row. Thanks in advance, Aarif |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |