If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What function to use - Counting numbers that meet a criteria??
Use the SUMIF function. This allows you to look in one
colmn for a specified entry and sum a second column corresponding to the specified entry. -----Original Message----- Hello, I have three columns: Product, Quantity and Price. Adjacent to that table of data I am doing some calculations. I have used "COUNTIF" to determine how many times a product appears in a column. So, for example, Product A appears 4 times in the column headed Product. What I'd now like to do is: wherever Product A is found, look into the column immediately to the right ("Quantity"), to find out how many Product A's were sold, and then sum that total in my calculations section? Please help! Greg --- Message posted from http://www.ExcelForum.com/ . |
Thread Tools | |
Display Modes | |
|
|