| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count only if
=SUM(IF(Sheet1!$K$5:$K$705=A12,IF(Sheet1!$M$5:$M$7 05=1,"PSP*")))
I'm trying to get a number value on Sheet 2 for how many times a cell starts with PSP but only if two cells over it states a predefined user name on Sheet2 hence the A12 in the formula. Can anyone point me in the right direction? I've asked alot of people and it seems to stump them. even when they think they can do it it ussually results in an error or incorrect value. exsample: A B C Joe 123 PSP12321323 Joe 132 INC12123424 Jack 123 PSP12132342 Jack 132 PSP12123424 Jack 123 INC12324213 The result I'm looking for is how many times does PSP show up next to a given user |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
