count cells with the same date that are NOTBLANK

Mixer

Hi,

I have 2 Grids (Sheets) and I would like to insert the formula in every row that counts the rows that are NOTBLANK in other sheet with the same date.

Sheet1 has several ROWS with the same dates. Sheet2 has only one date per ROW. I would like to COUNT Sheet1 rows that have equal Dates and insert it in every row in Sheet2. but the other criterion I neet is that Sheet1 column is NOT BLANK (but other than date column)

Mixer

This is the first part of the formula that works in excel but not smartheet

=COUNTIF({Sales-Commision-UnitA Range 3}, Date2)

Sales-Commision-UnitA Range 3 - is the whole column with Dates in Sheet1

Date2 - is the single row in Sheet2

 

Paul Newcome

Try this...

 

=COUNTIFS({Sheet 1 Range 1}, [Sheet 2 date column name]@row)

 

{Sheet 1 Range 1} would be your date column that has repeating dates in it.

 

[Sheet 2 date column name] would be the column name of whatever column your unique dates are in.

 

@row means it looks at the date in the row that the formula is in.

Mixer

Okey thanks, but how to include second criterion so that it would not count the rows that are empty in the next column?

Paul Newcome

It shouldn't count the blank cells in sheet one because the formula on sheet two is ONLY counting the number of time the date in the corresponding row shows up in sheet one.

 

Or am I misunderstanding what you need?