Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My first formula to get a count with no dollar amount;
=countif(January09!A1:A10,"test") - this gives me a count of test in columns A1 thru A10. Example = 3 My question: in columns B1 thru B10 is the dollar amount. Example for test = $100.00, totaling $300.00 for the 3 test found in Column A. How can I total the $300.00 only pulling out the test from column A =sumif(January09!A1:A10,"test" - this is where I need to pull in the $100.00 totaling $300.00 from column B (I keep having problems with different formulas). -- Don |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Formula Question | Excel Discussion (Misc queries) | |||
Excel formula question | Excel Discussion (Misc queries) | |||
Excel formula question. | Excel Worksheet Functions | |||
Excel Formula question | Excel Discussion (Misc queries) | |||
Excel Formula Question | Excel Worksheet Functions |