Help...I am so lost

bmxchick

bmxchick

New Member
Joined
Jun 29, 2011
Messages
13
:confused:I am trying to figure out how to find out how many pass or fails in a particular month(the vendor dates and the retake dates). And add how many exams were scheduled for each month from both the vendor dates and the retake dates.

Here is the sheet I am pulling the info off of.
<table class="MsoNormalTable" style="width: 385pt; margin-left: -1.35pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="513"> <tbody><tr style="height: 33pt;"> <td style="width: 64pt; border-width: 1.5pt 1pt; border-color: windowtext; border-style: solid; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="85">
VENDOR DATE​
</td> <td style="width: 88pt; border-width: 1.5pt 1pt 1.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="117">
PASS/ FAIL​
</td> <td style="width: 42pt; border-width: 1.5pt 1pt 1.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="56">
SCORE​
</td> <td style="width: 27pt; border-width: 1.5pt 1pt 1.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="36">
TPA​
</td> <td style="width: 58pt; border-width: 1.5pt 1pt 1.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="77">
RETAKE DATE​
</td> <td style="width: 62pt; border-width: 1.5pt 1pt 1.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="83">
PASS/ FAIL​
</td> <td style="width: 44pt; border-width: 1.5pt 1pt 1.5pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 33pt;" valign="top" width="59">
SCORE ​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
4/4/11​
</td> <td style="width: 88pt; background: none repeat scroll 0% 0% red; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
NO SHOW ​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
0​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/3/11​
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
PASS​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
728​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
4/14/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
537​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
7/21/11​
</td> <td style="width: 62pt; background: none repeat scroll 0% 0% yellow; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
NEED SCORE​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
4/18/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
630​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/7/11​
</td> <td style="width: 62pt; background: none repeat scroll 0% 0% red; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
NO SHOW​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
0​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
4/22/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
630​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/6/11​
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
FAIL​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
607​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
4/22/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
596​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/13/11​
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
PASS​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
840​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
5/6/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
525​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/10/11​
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
PASS​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
810​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
5/23/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
561​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/15/11​
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
FAIL​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
642​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
5/25/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
665​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
6/1/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
FAIL​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
630​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
6/8/11​
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
PASS​
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
705​
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
6/1/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
PASS​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
788​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
</td> </tr> <tr style="height: 21pt;"> <td style="width: 64pt; border-width: medium medium medium 1.5pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="85">
6/1/11​
</td> <td style="width: 88pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="117">
PASS ​
</td> <td style="width: 42pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="56">
883​
</td> <td style="width: 27pt; border-width: medium 1.5pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="36">
YES​
</td> <td style="width: 58pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="77">
</td> <td style="width: 62pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="83">
</td> <td style="width: 44pt; padding: 0in 5.4pt; height: 21pt;" valign="bottom" width="59">
</td> </tr> </tbody></table>

And here is the sheet I am putting the info on.
<table class="MsoNormalTable" style="width: 188.05pt; margin-left: -1.35pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="251"> <tbody><tr style="height: 20.1pt;"> <td colspan="3" style="width: 188.05pt; border-width: 1pt 1pt medium; border-style: solid solid none; border-color: windowtext black -moz-use-text-color windowtext; background: none repeat scroll 0% 0% rgb(0, 176, 240); padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="251">
2011 TOTAL VENDORS
​
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
</td> <td style="width: 37.8pt; border-width: medium 1.5pt 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
PASS
​
</td> <td style="width: 37.8pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
FAIL​
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
JANUARY​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
FEBRUARY​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
MARCH​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
APRIL​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
MAY​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
JUNE​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
JULY​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
AUGUST​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
SEPTEMBER​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
OCTOBER​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
NOVEMBER​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
DECEMBER​
</td> <td style="width: 37.8pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> <td style="width: 37.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="50">
</td> </tr> <tr style="height: 20.1pt;"> <td style="width: 112.45pt; border-width: medium 1pt; border-style: none solid; border-color: -moz-use-text-color windowtext; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" width="150">
TOTAL=​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" valign="bottom" width="50">
0​
</td> <td style="width: 37.8pt; padding: 0in 5.4pt; height: 20.1pt;" nowrap="nowrap" valign="bottom" width="50">
0​
</td> </tr> </tbody></table>
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Welcome to MrExcel.

With your first table in A1:G12 and your second table in I1:K15, in J2 enter:

=SUMPRODUCT(--(TEXT($A$2:$A$12,"mmmm")=$I3),--($B$2:$B$12=J$2))+SUMPRODUCT(--(TEXT($E$2:$E$12,"mmmm")=$I3),--($F$2:$F$12=J$2))

and copy down and across.
 
Upvote 0
Ok, I gave that a shot, but I am getting a circular reference loop. I also tried to do this:

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> =SUMPRODUCT(--(PASSFAILS1="PASS"),--(VENDOR702>=6/1/11>=6/30/11))


but unfortunately it counts my exams pass/fail, but it doesn't count them for a particular month.

:confused:
 
Upvote 0
I figured it out, your formula worked, i was putting in something wrong. I really appreciate you helping me!!
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Forum statistics

Threads
1,224,586
Messages
6,179,723
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top