How to find sum of odd numbers in a range of 1-100

[sunita sharma]

Hi

please help me to find out the sum of odd numbers in a range of 1-100 numbers


like 1+3+5+7+-------Upto 99


how it will find through a excel formula

 

[oldchippy]

Hi sunita sharma,


Welcome to the forum,try this array formula


=SUM( IF(MOD(A1:A100, 2) = 1, A1:A100, 0), 0)


Enter as

Ctrl+Shift+Enter

 

[Hui]

Sunita


Firstly, Welcome to the Chandoo.org forums

=SUM(2*ROW(OFFSET($A$1,,,100/2))-1) [b] Ctrl Shift Enter


or

=SUM(ROW(1:100)*MOD(ROW(1:100),2))

Ctrl Shift Enter[/b]

 

[NARAYANK991]

Sorry , I didn't read Hui's post before I posted ! Deleted mine.


Narayan