B15: 1-Jul-04
Then invoke:
=SUMIF($B$5:$B$12,"="&B15,$C$5:$C$12)-SUMIF($B$5:$B$12,""&EOMONTH(B15,0),$C$5:$C$12)
EOMONTH requires the Analysis Toolpak add-in (see Tools|Add-Ins)
stuarthow wrote:
Hi
Need some help with the SUMIF() function on Excel 2003 please:
I’m using this function as per example –
=SUMIF(month(B5:B12),month(B15),C5:C12)
where B5:B12 are regular dates (dd/mm/yyyy), B15 is a ‘month’ date (mmm
yyyy) and C5:C12 are ordinary numbers.
When entered, I get returned the warning box ‘The formula you typed
contains an error’
Help would be gratefully welcome.
Stuart
--
[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.
|