LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Question Chris N Excel Discussion (Misc queries) 2 June 23rd 08 09:55 PM
Excel formula question Murray[_2_] Excel Discussion (Misc queries) 2 May 29th 08 03:22 PM
Excel formula question. Jaycee Excel Worksheet Functions 10 November 17th 06 04:52 PM
Excel Formula question Jarad Excel Discussion (Misc queries) 2 March 2nd 06 02:53 PM
Excel Formula Question Joyce Excel Worksheet Functions 2 November 2nd 04 09:37 PM


All times are GMT +1. The time now is 03:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"