Results 1 to 10 of 12

Thread: Sumproduct Formula To Sum Range With Criteria On Numeric Text

Thread Tools
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

04-06-2013, 05:15 PM #2

Excel Fox

Administrator

Rep Power: 10

The formula is summing all of

3001

3000D

3000K

3000X

3002

3002D

3002K

3002X

3003

3003D

3003K

3003X

3004

3004D

3004K

3004X

3005

3005D

3005K

3005X

3006

3006D

3006K

3006X

3007

3007D

3007K

3007X

3008

3008D

3008K

3008X

3009

3009D

3009K

3009X

3015

3015D

3015K

3015X

And the value should be (2,175,478)

To get the value you are looking for, you could use

=SUM(IFERROR((--Sheet1!F1:F4310)>=3000,0)*IFERROR((--Sheet1!F1:F4310)<=3015,0)*(Sheet1!H1:H4310)) as array formula

Last edited by Excel Fox; 04-06-2013 at 05:19 PM. Reason: Additional Info

A dream is not something you see when you are asleep, but something you strive for when you are awake.

It's usually a bad idea to say that something can't be done.

The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

Join us at Facebook