Excel values

%3CLINGO-SUB%20id%3D%22lingo-sub-2719823%22%20slang%3D%22en-US%22%3EExcel%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719823%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Excel%20Home%20%26amp%3B%20Student%202016%20in%20Windows%2010%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20column%20of%20daily%20high%2Flow%20temperatures%20for%20various%20cities%20in%20this%20format%3A%3C%2FP%3E%3CP%3E89%2F67%3C%2FP%3E%3CP%3E105%2F56%3C%2FP%3E%3CP%3E90%2F45%3C%2FP%3E%3CP%3E30%2F-5%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20calculate%20the%20average%20high%20and%20low%20temps%20for%20a%20given%20month%20(28%20to%2031%20entries%20each)%2C%20ideally%20ending%20in%20the%20same%20high%2Flow%20format%2C%20but%20separate%20cells%20will%20do.%20My%20list%20goes%20back%20years%2C%20but%20I%20can%20break%20it%20into%20months.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EBob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2719823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719858%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146668%22%20target%3D%22_blank%22%3E%40bobrMI%3C%2FA%3E%26nbsp%3BWell%2C%20you%20need%20to%20split%20the%20high%2Flow%20column%20into%20two.%20For%2C%20instance%2C%20by%20using%20Text-to-columns%20on%20the%20Data%20ribbon.%20Then%20you%20could%20use%20a%20Pivot%20table%20to%20average%20the%20temperatures%2C%20but%20it%20would%20be%20helpful%20if%20you%20could%20upload%20a%20file%20with%20a%20couple%20of%20months%20of%20your%20real%20data%2C%20in%20stead%20of%20just%20some%20high%2Flow%20values.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719902%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20This%20was%20the%20first%20time%20I%20used%20the%20data%20ribbon.%20I'm%20a%20novice%20with%20Excel.%20And%20I%20got%20it%20to%20work%20on%20the%20third%20try!%20I%20will%20use%20this%20if%20necessary.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20was%20hoping%20it%20was%20just%20a%20matter%20of%20averaging%20the%20numbers%20before%20the%20%2F%20and%20then%20averaging%20the%20numbers%20after%20the%20%2F.%20I'd%20settle%20for%20summing%20the%20numbers.%20I%20can%20get%20the%20averages%20from%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Using Excel Home & Student 2016 in Windows 10

 

I have a column of daily high/low temperatures for various cities in this format:

89/67

105/56

90/45

30/-5

 

I want to calculate the average high and low temps for a given month (28 to 31 entries each), ideally ending in the same high/low format, but separate cells will do. My list goes back years, but I can break it into months.

Thanks,

Bob

2 Replies

@bobrMI Well, you need to split the high/low column into two. For, instance, by using Text-to-columns on the Data ribbon. Then you could use a Pivot table to average the temperatures, but it would be helpful if you could upload a file with a couple of months of your real data, in stead of just some high/low values.

@Riny_van_Eekelen 

Thank you. This was the first time I used the data ribbon. I'm a novice with Excel. And I got it to work on the third try! I will use this if necessary.

 

But I was hoping it was just a matter of averaging the numbers before the / and then averaging the numbers after the /. I'd settle for summing the numbers. I can get the averages from that.