Can I display results from two specific cells?

A

allthingstech

New Member
Joined
Nov 26, 2016
Messages
4
how can I display results from two columns using COUNTIF FUNCTION OR
=SUMPRODUCT(--ISNUMBER(SEARCH(" MAIN "," "&A1:A1000&" ")))
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
welcome to the forums.

Please post a sample of your data showing what you're trying to do (show data AND expected results).
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Function to find a portion of text in a cell
Replies
5
Views
482
Fluff
Fluff
D
  • Question
Trying to create a results sheet using two data ranges
Replies
0
Views
168
Doot
D
G
  • Solved
Print resultValue from VBA script
Replies
5
Views
428
georgeeye
G
R
  • Question
Display image based on value in a cell
Replies
3
Views
246
RodneyW
R
N
  • Solved
Reading across a row of cells to grab only one result.
Replies
8
Views
244
Fluff
Fluff

Forum statistics

Threads
1,214,905
Messages
6,122,174
Members
449,071
Latest member
cdnMech

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top