Excel Formula Question

[Donald]

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).

 

[Fred Smith]

Try it this way:

=sumif(January09!A1:A10,"test",January09!B1:B10)

Regards,
Fred.

 

[Elkar]

If I understand correctly, this should work:

=SUMIF(January09!A1:A10,"test",January09!B1:B10)

HTH
Elkar

 

[muddan madhu]

try this

=SUMPRODUCT((January09!A1:A10="test")*(January09!B1:B10))