I am trying to do a count by text criteria for a particular date. The formula that that is currently in the spreadsheet is time consuming and user unfriendly and needs to have the range adjusted daily:
=COUNTIF('Data-All-2012-13'!$G$2886:$G$2906,"NTH")
<TBODY>
</TBODY>
'Data-All-2012-13' is the sheet being referenced:
<TBODY>
</TBODY>
Neither of the 2 formulas below have worked:
=SUMPRODUCT(--('Data-All-2012-13'!$G$4:$G$3000=DATE(21,6,2013)),--('Data-All-2012-13'!$G$4:$G$3000=NTH"))
{=SUM(('Data-All-2012-13'!$D$4:$D$4002=$A312)*('Data-All-2012-13'!$G$4:$G$4002=B$4))}
any help would me muchly appreciated!
Thanks
=COUNTIF('Data-All-2012-13'!$G$2886:$G$2906,"NTH")
Date | NTH | STH | WEST |
20/6/2013 | Formula here totalling # of NTH for 20/6/2013 | ||
21/6/2013 | Formula here totalling # of NTH for 21/6/2013 |
<TBODY>
</TBODY>
'Data-All-2012-13' is the sheet being referenced:
Date | Group | ||
20/6/2013 | NTH | ||
20/6/2013 | STH | ||
20/6/2013 | NTH |
<TBODY>
</TBODY>
Neither of the 2 formulas below have worked:
=SUMPRODUCT(--('Data-All-2012-13'!$G$4:$G$3000=DATE(21,6,2013)),--('Data-All-2012-13'!$G$4:$G$3000=NTH"))
{=SUM(('Data-All-2012-13'!$D$4:$D$4002=$A312)*('Data-All-2012-13'!$G$4:$G$4002=B$4))}
any help would me muchly appreciated!
Thanks