Ask Your Question

Counting Date Occurances [closed]

asked 2014-02-22 22:52:50 +0200

CQuiles gravatar image

I need to count cells that are on two seperate sreadsheets. The first spreadsheet is organized by date and the second spreadsheet is where data is entered also by date. I need it to be able to detect the different dates from spreadsheet 2 and organize count the occurances of that date in spreadshhet 1. Does that make sense?

Please help!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:58:40.168758

1 Answer

Sort by » oldest newest most voted

answered 2014-02-23 02:46:41 +0200

Aigars gravatar image

You can use a formula "date1-date2" and if both dates are the same you'd get result 0, but if not - some number, you can use IF function to enter "0" if dates are the same and 1 if they are not and then you can count how many 1's you have... I assume that's what you want - to find out how many dates do not match.

IF(date1-date2=0;0;1) and COUNTIF(range1:range1;1)

edit flag offensive delete link more

Question Tools



Asked: 2014-02-22 22:52:50 +0200

Seen: 614 times

Last updated: Feb 23 '14