sum with critera

[moizs]

I have data in which there is one row with numbers

i want to sum up with a criteria

the data is some what like this

100

150

175

200

i want to sum like total upto 100

total from 101 to 150 etc etc

 

[Hui]

Moizs


Do you mean like:


=SUMIFS(A1:A4, A1:A4, ">100", A1:A4, "<=150")


or


=SUMPRODUCT((A1:A4>100)*(A1:A4<=150), A1:A4)

 

[moizs]

Thanks HUI, U R Indeed a Excel Ninja