Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
How do I link data from a horizontal range to a vertical range? | Excel Worksheet Functions | |||
Show Data In Range not appearing in Separate Range | Excel Discussion (Misc queries) | |||
How do I change a range name back to the underlying data range? | Excel Worksheet Functions |