SUMIF function

[razwy13]

hello everyone,

I have a problem. Can you tell me what is the problem with the formula. it give me an error.

=SUMIF(MONTH(B2:M2),"=1",B3:M3)

where B2:M2 is a datas range
and B3:M3 is the values ranges

Thanks

 

[Jonmo1]

Welcome to the board...

Try

=SUMPRODUCT(--(MONTH(B2:M2)=1),B3:M3)


However, you may find that this (obviously) doesn't care what year the date is...
So if your dates may contain multiple years, you may get inaccurate results..

If you need to account for the year as well, try

=SUMPRODUCT(--(TEXT(B2:M2,"mmmyyyy")="Jan2011"),B3:M3)

 

[razwy13]

Thanks veryyyyyyyyyy much. it works perfectly.
Introduceţi text ori o adresă de site web sau traduceţi un document.
Anulaţi
<input style="display: none;" name="file" id="file" size="40" type="file">
Traducere din Română în Engleză