T
TrickyT
I hope someone can help[ me with this, I have found several solutions but
none have worked 100%
I have 2 woorksheets, one which has the data entered onto it and the
other does a summary.
The first data sheet has column A which will have dates entered from
1/1/2005 to 31/12/2005
The second column B has a type entered (6 different from a drop down box)
The second summary sheet will be used to summarise the data
Column A3 to A8 will have the 6 data types and column B2 to M2 will have
the months.
I need a formula to cont the number of occuences for each type in each
month.
I have tried
=SUMPRODUCT((Damages!A2:A151>=DATE(2005,1,1))*(Damages!B2:B151=A2)-
SUMPRODUCT((Damages!A2:A151>=DATE(2005,1,31))*(Damages!B2:B151=A2)))
Which works ok for january, but formula goes wrong when I change the
dates from January to February
I think I need something like this but cannot get it to work
=SUMPRODUCT((Damages!$A$2:$A$151=
Formula to either itentify month or specify dates between
*(Damages!B2:B151=A2))
Regards
Trevor
none have worked 100%
I have 2 woorksheets, one which has the data entered onto it and the
other does a summary.
The first data sheet has column A which will have dates entered from
1/1/2005 to 31/12/2005
The second column B has a type entered (6 different from a drop down box)
The second summary sheet will be used to summarise the data
Column A3 to A8 will have the 6 data types and column B2 to M2 will have
the months.
I need a formula to cont the number of occuences for each type in each
month.
I have tried
=SUMPRODUCT((Damages!A2:A151>=DATE(2005,1,1))*(Damages!B2:B151=A2)-
SUMPRODUCT((Damages!A2:A151>=DATE(2005,1,31))*(Damages!B2:B151=A2)))
Which works ok for january, but formula goes wrong when I change the
dates from January to February
I think I need something like this but cannot get it to work
=SUMPRODUCT((Damages!$A$2:$A$151=
Formula to either itentify month or specify dates between
*(Damages!B2:B151=A2))
Regards
Trevor