Text search using if function in exl 2007

[deepak_message]

Hi to All,

Recently I joined this forum. I am having one problem in excel. I am looking ifcount() function inside the if() function. my table is ..

B c
<table border="0" cellpadding="0" cellspacing="0" height="60" width="225"><col style="mso-width-source:userset;mso-width-alt:5632;width:116pt" width="154"> <col style="width:48pt" width="64"> <tbody><tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:116pt" height="20" width="154">new</td> <td class="xl63" style="border-left:none;width:48pt" width="64">abc
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">old</td> <td class="xl63" style="border-top:none;border-left:none">bac</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">new</td> <td class="xl63" style="border-top:none;border-left:none">abc</td> </tr> </tbody></table>
I am using formula =IF(C3:C5="abc", COUNTIF(B3:B5,"new"), 0) that means where "abc" text comes inside the C column, B column's "new" text should be count . after running this function, an error gives.

The result should be come - 2.

Please help me for the correct function. thanks in advance.

 

[Domenic]

Try...

=COUNTIFS(B3:B5,"new",C3:C5,"abc")

 

[deepak_message]

Thanks you very much , You rock

 

[Domenic]

You're very welcome! And thanks for the feedback!

 

[deepak_message]

I have one more concern ..........

I am working on biggest project, which is based on excel only.

I am looking excel expert help, who can help to get it done the below tasks.

1. How to add value every day in cell
This is related to adding cells value at one cell if enter the value on daily basis.
eg. I am entering value at...

first day A1 10 and A2 20 its sum is =sum(A1:A2)= 30
Second day A1 20 and A2 30 its sum is =sum(A1:A2)= 80(because, it should be stored value of the first day also)

2. How to flush cell value in one day and one week automatically

3. How to constant the day if using the =today() function
Actually, if I am using =today() function in excel and an open another day it shows the current day. but I am looking that date should be not change.

4. I have two excel file,one file has five sheets(As per the day name(monday to friday)), in which users input the value on the respected day sheet.

and second excel file, getting the value where users are entering value in the first file.

what I looking is, the only second file fetch the value from the first file, according to day only.

I would appreciate the help, because this is serious project.

Thanks,