negative value problems

beez

New Member
Joined
Aug 9, 2002
Messages
7
I hope this HTML stuff shows up! If you look at the bay totals, how do I get rid of the negative value that always carries over?
Woodlot bays addin.xls
ABCDEFGHIJKLM
7WoodlotBays&RainGauge
8
9ReadingDayTuesdayWednesdayThursdayFridayFridayMonday
10MorningMorningMorningMorningAfternoonMorning
11Bay1Bay2Bay3Bay4Bay5Bay6RainGauge
12WeekMondayr/gTuesdayr/gWednesdayr/gThursdayr/gFridayr/gSat/SunWeekly
1329/7/02-4/8/0250,001,00050,002,00050,003,00050,004,00050,005,00050,006,000
145/8/02-11/8/0250,007,00050,008,00050,020,00050,025,00050,040,00050,070,000
1512/8/02-18/8/0250,090,00050,110,000
1619/8/02-25/8/02
1726/8/02-1/9/02
18YearlyTotals21,00022,000-50,097,0006,00016,00031,000
Sheet1
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
beez,

This is certainly not a "pretty" answer, but since you haven't gotten a response, I thought I'd throw this your way:
Book1
ABCDEFGHIJKLM
7WoodlotBays&RainGauge
8
9ReadingDayTuesdayWednesdayThursdayFridayFridayMonday
10MorningMorningMorningMorningAfternoonMorning
11Bay1Bay2Bay3Bay4Bay5Bay6RainGauge
12WeekMondayr/gTuesdayr/gWednesdayr/gThursdayr/gFridayr/gSat/SunWeekly
1329/7/02-4/8/0250,001,00050,002,00050,003,00050,004,00050,005,00050,006,000
145/8/02-11/8/0250,007,00050,008,00050,020,00050,025,00050,040,00050,070,000
1512/8/02-18/8/0250,090,00050,110,000
1619/8/02-25/8/02
1726/8/02-1/9/02
1821,00022,00013,0006,00016,00031,000
Sheet1
 
Upvote 0
An easier way:
Transpose Access Data Help.xls
ABCDEFGHIJKLM
2ReadingDayTuesdayWednesdayThursdayFridayFridayMonday
3MorningMorningMorningMorningAfternoonMorning
4Bay1Bay2Bay3Bay4Bay5Bay6RainGauge
5WeekMondayr/gTuesdayr/gWednesdayr/gThursdayr/gFridayr/gSat/SunWeekly
629/7/02-4/8/0250,001,00050,002,00050,003,00050,004,00050,005,00050,006,000
75/8/02-11/8/0250,007,00050,008,00050,020,00050,025,00050,040,00050,070,000
812/8/02-18/8/0250,090,00050,110,000
919/8/02-25/8/02
1026/8/02-1/9/02
11YearlyTotals21,00022,00013,0006,00016,00031,000
Sheet3


NOTE! you could have used SUMPRODUCT in your original formula, and non-array entered it.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top