Create counter for combinations of cell matches within same row

		Microsoft Office Forums > Microsoft Excel > Excel
Create counter for combinations of cell matches within same row

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-03-2023, 07:31 AM

Pecoflyer

Windows 10 Create counter for combinations of cell matches within same row

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=SUMPRODUCT(--(ISNUMBER(SEARCH("P",$C$2:$C$1129)))*($D$2:$D$1129="office"))

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
lookup the date beside a cell that matches a value	oscarlimerick	Excel	2	01-30-2022 09:38 AM
how to create a Microsoft word 2016 tempalte so it matches a CSS template	bboerma	Word	3	11-21-2017 08:18 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
cell text to auto populate if criteria matches	Jackie	Excel	2	02-06-2015 07:58 PM
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?	alshcover	Excel	2	06-03-2014 12:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 AM.