| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting values for variables in separate columns
Sorry I'm back with another question, and not sure if it will be picked up at
the end of my last string, so I'm adding this in as a new question - sorry I'm a rookie to the Discussion Forum.... I'm working on a spreadsheet and thought the same forumla would work (it worked for preivous formula when numbers where involved). This time I'm checking two seprate column and want to count the number of results if the value in one field is Gap and the value in the other column is SME or variables as I define. Would you take a quick look at this formula and see where I'm going wrong - sorry! =SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project Master'!F82:F369=SME)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count values in two columns | Excel Discussion (Misc queries) | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| matching values in columns that contain duplicates | Excel Discussion (Misc queries) | |||
| Counting based on values in two columns? | Excel Worksheet Functions | |||
| How do I match identical values in 2 columns and then sort? | Excel Discussion (Misc queries) | |||
Threaded Mode
