An alternative would be to split the date so you have say: -
Row Column A Column B
1 2 June
2 24 June
3 13 April
You could then use SUMIF. Using the example above you would use the
following formula: -
=SUMIF(1B:3B,"June",1A:3A)
To explain the above: -
The formula first of all searches 1B:3B
The second part "June" is what it looks to find in the range 1B:3B
The final bit 1A:3A is the list of values and it calculates the sum of the
corresponding cells where it finds "June" or whatever criteria you set.
I hope that this helps.
--
David
"PamelaJ" wrote:
I'm trying to sum information on another worksheet.
01-Jun in column a and 15 in column b
25-Jun in column a and 20 in column b
01-Aug in column a and 30 in column b
to give me total for Jun in another worksheet with a total value of 35
(ie adding just the month of June
Can anyone help?
--
PamelaJ
------------------------------------------------------------------------
PamelaJ's Profile: http://www.excelforum.com/member.php...o&userid=36387
View this thread: http://www.excelforum.com/showthread...hreadid=561701