Thank you! You're a genius!!!
"Bob Phillips" wrote:
=SUMPRODUCT(--(TEXT(A1:A25,"dddd")="Monday"),B1:B25)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"tamato43" wrote in message
...
If the cell is formatted to show a date as follows:
"Monday 3/21/2005"
How can I create a "SUMIF" condition to say".....
SUMIF "Monday" shows anywhere in the cell.
|