Thread: How to count the frequency of data and also tally value from an array of Excel record
View Single Post
 
Old 09-07-2011, 07:57 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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)
Reply With Quote