Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Question
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Question
Try it this way:
=sumif(January09!A1:A10,"test",January09!B1:B10) Regards, Fred. "Donald" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Question
If I understand correctly, this should work:
=SUMIF(January09!A1:A10,"test",January09!B1:B10) HTH Elkar "Donald" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Question
try this
=SUMPRODUCT((January09!A1:A10="test")*(January09!B 1:B10)) On Feb 4, 12:52*am, Donald wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |