COUNT Cells

mypig7

Active Member
Joined
Sep 27, 2004
Messages
284
I have 2 columns on Sheet 2

In column 1 it says Mon all the way down to A10
Then Tues for a few more cells below, then Weds for a few cells and so on.
The list is sorted in order

To the right in Column B some cells have numbers in them and some are blank
On Sheet 1 I want a summary, so it would say:

"Mon" in one cell
And to the right of Mon a count of how many cells next to Mon in Column B (Sheet 2) that have something in them.

How do I do it?

Tried a combination of AND, COUNTIF...
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
8,804
Try:

=COUNTIFS(Sheet2!A:A,"Mon",Sheet2!B:B,">0")
 
Last edited:

Forum statistics

Threads
1,078,394
Messages
5,339,943
Members
399,341
Latest member
natalyg3c

Some videos you may like

This Week's Hot Topics

Top