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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
CyrusTheVirus

CyrusTheVirus

Well-known Member
Joined
Jan 28, 2015
Messages
744
Office Version
  1. 365
Platform
  1. Windows
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

T
  • Solved
Single formula to display results in adjacent columns
Replies
3
Views
289
Fluff
Fluff
S
  • Question
INDEX MATCH | Multiple Results From 12 Different Tables
2
Replies
10
Views
864
Fluff
Fluff
S
  • Solved
VBA Coding Help - Incorporate Text Boxes based on results
Replies
3
Views
246
DanteAmor
DanteAmor
T
  • Question
SUMIF that only works if the cell it's counting is a typed number and not a formula
Replies
3
Views
244
Fluff
Fluff
C
  • Question
Displaying Autofiltered results in a Llstbox
7 8 9
Replies
87
Views
3K
chazrab
C

Forum statistics

Threads
1,191,211
Messages
5,985,298
Members
439,956
Latest member
FrazzledCat

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
Top