Combining a SUMPRODUCT and a COUNTIF formula

[broncos347]

Hi, I have these two formulas;

=SUMPRODUCT(--('All Station Surveys with Type a'!$E$6:$E$2000="accepted"),--('All Station Surveys with Type a'!$G$6:$G$2000="in progress"),--('All Station Surveys with Type a'!$C$6:$C$2000="visual"))

=COUNTIF('All Station Surveys with Type a'!D:D,">="&B2)-COUNTIF('All Station Surveys with Type a'!D:D,">"&AA2)

which i would like to combine in to one formula to show how many of a certain type of survey was done inbetween certain dates.

Is there anyone who can help?

 

[Aladin Akyurek]

Hi, I have these two formulas;

=SUMPRODUCT(--('All Station Surveys with Type a'!$E$6:$E$2000="accepted"),--('All Station Surveys with Type a'!$G$6:$G$2000="in progress"),--('All Station Surveys with Type a'!$C$6:$C$2000="visual"))

=COUNTIF('All Station Surveys with Type a'!D:D,">="&B2)-COUNTIF('All Station Surveys with Type a'!D:D,">"&AA2)

which i would like to combine in to one formula to show how many of a certain type of survey was done inbetween certain dates.

Is there anyone who can help?

Try...

=SUMPRODUCT(
--('All Station Surveys with Type a'!$E$6:$E$2000="accepted"),
--('All Station Surveys with Type a'!$G$6:$G$2000="in progress"),
--('All Station Surveys with Type a'!$C$6:$C$2000="visual"),
--('All Station Surveys with Type a'!$D$6:$D$2000>=B2),
--('All Station Surveys with Type a'!$D$6:$D$2000<=AA2))