| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup values in 2 columns, count and then multiply??? HELP!
Hi
I know it can be done but it escapes me at this stage. Please help!!! I have a spreadsheet which looks like A B 1 Dog 12/7/07 2 Cat 13/7/07 3 Dog 4 Dog 12/7/07 5 Cat 6 Dog 12/7/07 7 Dog 12/7/07 I want to return a count of the number of times that dog occurs in column A and has a corresponding value in column B (is not blank) - so in this case answer would be 4. I also then want to multiply the answer by 150 (4*150). Can someone help? cheers Debbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding values within multiply columns | Excel Discussion (Misc queries) | |||
| can vlookup be used to if the lookup values are in two columns? | Excel Worksheet Functions | |||
| Formula to count values in two columns | Excel Discussion (Misc queries) | |||
| I would like to Count values in two columns. | Excel Worksheet Functions | |||
| How do I count values across multiple columns? | Excel Worksheet Functions | |||
Threaded Mode
