returning a sum value

[kyoko]

example:
A B
1 31-Oct 10000
2 31-Oct 3000
3 31-Oct 5000
4 01-Nov 6000
5 01-Nov 2000
6
7

On the above example, i want to get the sum of column B from October 31
only, the value from Nov 1 was not included. what formula is appropriate for
this situation? i only want to get the sum for Oct 31. Please do help me, i
really need it. thanks in advance.

 

[Pete_UK]

Put the date in C1, for example, then this formula in D1:

=SUMIF(A:A,C1,B:B)

Hope this helps.

Pete

 

[KC]

what Pete has suggested would work, however if you want to sum up between a
given range of dates (say from 01-Oct-09 to 31-Oct-09) then SUMIF would not
work for multiple conditions, but if this is your requirement then one of the
work around would be to use

=SUMIF(A2:A6,TRUE,B2:B6)
where 1st row is column header.
and then put a auto filter to the column headers and use custom filter
condition to Date column such that is now show only the required range.
this would work because SUMIF adds only the visible rows and not the hidden
rows.

please note: after hiding or unhiding the rows the total may not refresh,
you would need to hit F9 for immediate refresh, or wait for some other even
to trigger.

hope this additional information helps.

-kc
* click YES if this helps.