| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Function help required
=sumproduct(--(b1:B1000="AA),--(F1:F1000="BB"))
Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "KSteven" wrote in message ... Hi, I have a spreadsheet of data, and am currently creating tables at the top for and easy overview. I have done some basic countif statements, however I need to create one that counts 1 record when it meets 2 criteria in different columns for example... I need to count column B if data matches "AA" and in the same row column F = "BB" If columns B and F match my criteria than I want it to count as 1 else 0. Hopefully this makes sense !!  -- KSteven ------------------------------------------------------------------------ KSteven's Profile: http://www.excelforum.com/member.php...o&userid=31401 View this thread: http://www.excelforum.com/showthread...hreadid=510986 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count function not working, keeps displaying 0 | Excel Worksheet Functions | |||
| Function to count unique values? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| Count If Function | Excel Worksheet Functions | |||
| count if function with if statements | Excel Worksheet Functions | |||
Hybrid Mode
