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

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

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

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