How to count the frequency of data and also tally value from an array of Excel record

		Microsoft Office Forums > Microsoft Excel > Excel
How to count the frequency of data and also tally value from an array of Excel record

FAQ

Thread Tools

Display Modes

09-07-2011, 07:57 AM

OTPM

Windows 7 32bit How to count the frequency of data and also tally value from an array of Excel record

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Hi Kim

Simply cut and paste the table to Sheet 2 and modify each formula from:

=SUMIF(B:B,"Gr-4",C:C)
to
=SUMIF(Sheet1!B:B,"Gr-4",C:C)

Good luck.
Tony(OTPM)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to update record in Access 2003 using Userform in Excel	primmer3001	Excel Programming	0	08-29-2011 04:25 PM
How to count the total cells that contains text data?	Learner7	Excel	1	06-30-2011 04:13 PM
Count in Excel	zanat0s	Excel	3	06-09-2011 10:53 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 PM.