Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to count two different text values within two columns.
Column A contains sentences and Column B contains various values. Example of small sentences in Column A: Custom XX Upgrade Printing reports on XX Custom YY Upgrade Example of values in Column B: AAAA BBBB BBBB What I need to do is count groups of records, like only counting the records that contain €œXX€ anyplace witihin Column A plus have €œXXXX€ in Column B. I tried countif statements with no success. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |