Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho

preview_player
Показать описание

Amazing array formula from pmsocho at YouTube
See how to count with OR Criteria using an array formula:

1. DCOUNTA (non-array formula)
2. SUMPRODUCT and COUNTIF (array formula)

  1. excelisfun
  2. Excel 2013
  3. Excel 2003
  4. Excel 2007
  5. Excel 2010
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:05:55

Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho

Excel Magic Trick 0:05:55

Excel Magic Trick 1015 Counting With OR Criteria SUMPRODUCT & COUNTIF Formula from pmsocho

Excel Magic Trick 0:20:12

Excel Magic Trick 1482: SUMPRODUCT, DCOUNTA or SUM & IF for Counting with OR Logical Test

Excel Magic Trick 0:04:53

Excel Magic Trick 1477: COUNTIFS & AND Functions for Duplicate Event Codes AND Task = 'Spec...

Excel Magic Trick 0:06:57

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

How Do I 0:03:19

How Do I Count Data In Excel With Multiple Criteria

Excel Magic Trick 0:12:28

Excel Magic Trick 1197: OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?

Excel Magic Trick 0:05:46

Excel Magic Trick 1246: Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT

Excel Magic Trick 0:07:14

Excel Magic Trick 1236: Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?

Excel Magic Trick 0:27:03

Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples)

Excel Magic Trick 0:08:38

Excel Magic Trick 980: OR and AND Counting Criteria In One Formula, Boolean or MATCH?

Excel Magic Trick 0:09:41

Excel Magic Trick 1027: Array Formula To Count Unique Yes Votes For A Given First & Last Name

Excel Magic Trick 0:05:16

Excel Magic Trick 1248: Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT

Excel Magic Trick 0:06:38

Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test

Excel Magic Trick 0:02:28

Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment

Excel Magic Trick 0:09:55

Excel Magic Trick 1020: What Lens Do You Look Through When Solving Excel Problems

Excel Magic Trick 0:06:53

Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted

sumproduct works as 0:00:43

sumproduct works as countif

How use COUNTIF 0:03:49

How use COUNTIF and COUNTIFS in Microsoft Excel

SUMPRODUCT Count the 0:04:55

SUMPRODUCT Count the text within a range

How to count 0:03:36

How to count items in Excel using the COUNTIF function

Excel Magic Trick 0:10:08

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

How to Count 0:03:43

How to Count values between two years using COUNTIFS and SUMPRODUCT @datachamp32

Excel : Array 0:08:43

Excel : Array CountIF

Комментарии
Автор

You are welcome. Mike is real master here. I learned a lot from him!

pmsocho
Автор

Thank you so much for your lessons. You have helped so many of us. We really appreciate all your contributions to our work success.

hoiyinwan
Автор

As you know, I am not really a master of Excel, just a guy having fun with Excel. But I do know this: As an Online Excel Team, we are amazing!! Thanks, pmsocho!!!

excelisfun
Автор

I do not have videos on those topics. Perhaps in the future.

excelisfun
Автор

I jsut want to say that this channel is so informative for me. You really have many things you can teach me!

JamesStallion
Автор

Thank you so much, this is awesome information. I will definitely be exploring your other videos!

terryblocklear
Автор

Where do i purchase your ebook? And thanks for all the great videos and support

TheandOnlyToB
Автор

hello there!
I always learn something new from your videos. Thank you for making them
I was wandering if you or Mr Excel can make some videos using the new Add-in PowerPivot tool, or how to make Dashboards for that matter?


WillisGomez
Автор

Hi
Please can you tell my how can i count a particular text in a column excluding certain rows, eg rows s2:s500 and count rows that say on track excluding text in row s4 / s13/s18

mildredsouza
Автор

Mike,
Is there a way to contact you regarding a few Excel questions?

Bview
Автор

thank you
MAX(MATCH(f3:f5;c2:C25;0))

omkhxxg
Автор

For back and forth dialog to get Excel solutions try THE best Excel question site:

mrexcel [dot] com/forum

Otherwise, you can send e-mail through YouTube (which is not an efficient means to get Excel solutions).

excelisfun
Автор

You can purchase it here:

mrexcel [dot] com

Thanks for the support in buying the book!

excelisfun
Автор

Dutch, English and German I understand, but the pmsocho's channel unfortunately is Polish...

ModelbaanTBM
Автор

Hello,
i heard that the if-error fn. take more time to process so iam replaced it in my file and i think no difference
my old formula is
جديد"))
my new one is
جديد");"موجود")
pls provide me if the new one is more complex or take more time to proceed
Best regards

ahmed