How to use lookup functions to calculate statistical paras using named ranges

		Microsoft Office Forums > Microsoft Excel > Excel
How to use lookup functions to calculate statistical paras using named ranges

FAQ

Thread Tools

Display Modes

05-08-2020, 01:21 AM

Intruder

Windows XP How to use lookup functions to calculate statistical paras using named ranges

Office 2007

Advanced Beginner

Join Date: Dec 2010

Posts: 59

Want to extend formulae from previous attempt for means, N and sd

Thanks to p45cal this problem has been solved. However, I want to expand the formulae to individual genders male and female. Calculations of means and N are ok, I'm still suffering with sd.
I attached the updated Excel with the cells for formulae needing support in red color.
Any help?
Roland

Attached Files

msofficeforums44765for forum.xlsx (21.0 KB, 8 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use of named ranges based on cell content	Intruder	Excel	12	02-25-2019 09:42 AM
accessing individual row data in named ranges	MimiCush	Excel	25	09-27-2018 01:01 PM
Named Ranges Help	SavGDK	Excel	5	05-01-2017 09:41 AM
How to use named ranges in excel vba?	bosve73	Excel Programming	4	01-25-2012 09:26 AM
Dynamic Named Ranges using text	hannu	Excel	0	06-22-2010 04:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 AM.