CountIFs

[lohith1984]

Hello XL Experts,

I am in need of your assistance for my problem in excel, and i hope you can help me out.
Here is the scenario: I have 2 worksheets in a workbook one worksheet (Sheet1) has data corresponding to the date and the other worksheet (Sheet2) is where i need to extract no. of transactions made on particular date.
This can be done by using CountIFs or SumIFs function in 2007, but the problem is, in the sheet 1 the format of date is "04/19/10 04:00 am" and in the second sheet the format is "04/19/10", in this case the formula in sheet 2 cannot match with the date in sheet 1. Please advice.

Regards,
Lohith

 

[Aladin Akyurek]

Hi Aladin,

The formula isnt working for me, i am getting an error message #VALUE!

Regards,
Lohith

That should not happen...

Do you have any formulas in the relevant ranges on Sheet1? If so, would you post them here?

 

[lohith1984]

There are no Formulas in the relevant ranges in "Sheet1"

Regards,
Lohith

 

[Aladin Akyurek]

There are no Formulas in the relevant ranges in "Sheet1"

Regards,
Lohith

Would you re-build the exhibit in post #9 into a clean workbook along
with the suggested formulas and report back the results you get?

 

[lohith1984]

Hi Aladin,

The formula is working fine for me now.

Thank you very much for all your assistence.

Regards,
Lohith

 

[Aladin Akyurek]

Hi Aladin,

The formula is working fine for me now.

Thank you very much for all your assistence.

Regards,
Lohith

Glad to hear that. And you are welcome.