Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count if ? formula needed! | Excel Discussion (Misc queries) | |||
formula for current stock count needed | Excel Worksheet Functions | |||
FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES | Excel Worksheet Functions | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Need formula to count specific cells in a row | Excel Worksheet Functions |