Date-wise Calculation

[azad092]

Dear members
good evening
I have a data entry excel file with different sheets One sheet is data entry and others are on different reports these reports are generated from the data entry sheet by using different formulas
for example =COUNTIF(MTN!G2:G399,"RTA")
I want that in this formula instead of using the range G2:G399 only column G should be used and the range of specific data should be base on date range. if it is possible please guide me

 

[gaz_chops]

Try this as a start

=COUNTIFS(MTN!G2:G399,"RTA",MTN!G2:G399,">="&A1,MTN!G2:G399,"<="&B1)

A1 = start date
B1 = end date

 

[azad092]

=COUNTIFS(MTN!G2:G399,"RTA",MTN!G2:G399,">="&A1,MTN!G2:G399,"<="&B1)

thanks for your kind attention
No dear this idea is not useful
but I want to share an idea, maybe you understand and also help me
look
I have tow Sheets MTN (for Data entry) and G Report( for Report)
I am using this formula in G Report sheet to calculate the data =COUNTIF(MTN!G2:G399,"RTA")
In G Report, Cell Z3 I enter the specific date
to define the date range I think the following formula add with the above countif formula like as

=IF(ISNUMBER(MATCH(Z3,MTN'!B2:B399,0)),COUNTIF(MTN!G2:G399,"RTA","0")
but I am in trouble how to combine tow formulas
if you know please guide me
In this way I will become able to generate a report of any date by just change the date in Cell Z3

 

[gaz_chops]

It would be easier if you posted some sample data using the XL2BB option, showing what results you expect.

Trying to guess what you want is never a good idea, but maybe

=COUNTIFS(MTN!G2:G399,"RTA",MTN'!B2:B399,Z3)