sumproduct question

[maheshr68]

Greetings!!

=SUMPRODUCT((F1:F15928,"18/2/2011")*(k1:k15928="*emoved")*(L2:L6152="*ishwa*"))

am i messing anything? cant get it to work

Best Regards,
Mahesh

 

[T. Valko]

Greetings!!

=SUMPRODUCT((F1:F15928,"18/2/2011")*(k1:k15928="*emoved")*(L2:L6152="*ishwa*"))

am i messing anything? cant get it to work

Best Regards,
Mahesh

A few things wrong with that...

The "date" is not being evaluated as a true Excel date. Put the date in a cell then refer to that cell.

SUMPRODUCT doesn't support wildcards. Use cells to hold the criteria.

One range is not the same size as the other ranges: L2:L6152

All ranges must be the same size.

What version of Excel are you using?

 

[Aladin Akyurek]

Greetings!!

=SUMPRODUCT((F1:F15928,"18/2/2011")*(k1:k15928="*emoved")*(L2:L6152="*ishwa*"))

am i messing anything? cant get it to work

Best Regards,
Mahesh

That formula is not well-formed...

Do you mean something like

=COUNTIFS(F1:F15928,DATE(2011,2,18),K1:K15928,"*emoved",L1:L15928,"*ishwa*")

on Excel 2007 or later;

Or...

=SUM(
    IF(F1:F15928=DATE(2011,2,18),
    IF(ISNUMBER(SEARCH("emoved",K1:K15928)),
    IF(ISNUMBER(SEARCH("ishwa",L1:L15928)),1))))

This one works on all versions and requires that you confirm it with control+shift+enter, not just enter.