LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 557
Default Formula needed to SUM and COUNT in specific way

Hi all, I have data in Sheet1 and Sheet2 as shown below

Sheet1
A B-----col
Data Amount----headings
XX 2
YY 4
SS 5
XX 9
GG 8
HH 3
SS 5

Sheet2
A B C---col
Data Sum Count---headings
XX
SS
HH

I need some kind of SUM formula in column B and COUNT formula in
column C of Sheet2 which should only SUM and COUNT the amounts in
column B of Sheet1 of which same row value in column A of Sheet 1
match with column A of Sheet2. So the result should be like as shown
below.

Sheet2
A B C---col
Data Sum Count---heading
XX 11 2
SS 10 2
HH 3 1

Please can any friend have any formula in mind for this kind of
calculation. Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count if ? formula needed! katagrga Excel Discussion (Misc queries) 3 June 24th 09 04:26 AM
formula for current stock count needed Kath Excel Worksheet Functions 2 June 9th 07 04:25 PM
FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES Rhonda1 Excel Worksheet Functions 4 January 31st 06 12:13 AM
More Help Needed with Count formula Greegan Excel Worksheet Functions 4 July 31st 05 06:31 PM
Need formula to count specific cells in a row JanetP Excel Worksheet Functions 2 April 28th 05 02:12 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"