Formula to calculate different dates - Sumif or countif?

[harryhu]

Hi there

A question on how can I get a formula calculate the following question for me.

What I want is to count all these finish date that isn't the same as the start date. Then sum up the number of gadgets that doesn't match.

I tried to use countif formula but for whatever reason it won't recognise the difference between the dates.

Start Date Finish Date
26/11/2009 27/11/2009

Help!

[ConneXionLost]

Hi harryhu,

I don't understand what you mean by "gadgets that doesn't match" (you didn't provide a sample spreadsheet), but this formula will give you the count of non-matching dates in your list:

Please Login or Register  to view this content.

Just adjust the ranges as required.

Cheers,

[darkyam]

ConneXionLost, what is the purpose of making sure A > 0? If it is blank, then there would logically be no finish date, meaning B would be blank and so would equal A, which would cause Sumproduct to ignore it.

Harryhu, if I understand correctly, you want to sum the gadgets that took more than a day to make. If those are in C, then use =SUMPRODUCT(--(A2:A100<B2:B100),C2:C100)

[ConneXionLost]

Hi darkyam,

You're right, I had originally written the formula to count the dates that matched, and required a way to eliminate the blank rows (A>0). Just before posting, I realized the OP wanted the opposite, so I changed the "=" to "<>" but forgot to remove the A>0.

Cheers,