View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DMW[_2_] DMW[_2_] is offline
external usenet poster
 
Posts: 5
Default How do I sum data within a range?

I need to sum a range of date based on number of days? Depending on the
aging (last column) I need to total the # of bulbs, Delta Watts, Base watts
on a seperate summary sheet. I am using excel 2003, I was able to calculate
the <30 using thisformula =SUMIF(Sheet1!U:U,"<30",Sheet1!Q:Q), but I am
having difficulty with a range <=30-=60 and so on. Please help?


# Bulbs D Watts Base Watts DSM WattsAging
11 398 535 137 7
12 549 745 196 26
16 1210 1575 365 40
22 1111 1450 339 40
6 312 415 103 43
4 184 240 56 78
8 445 575 130 99
10 468 620 152 148
14 923 1200 277 148

I appreciate your help with this.

DMW