Related to: http://www.excelforum.com/excel-form...t-formula.html
Is there a way to write the formula so that it DOESN'T sum the values, if a word from an array is found in any of the cells?
One poster listed this formula that works (it calculates the total number of cells that have the specified names of fruit in them):
=SUM(COUNTIFS(E2:E6,"*"&{"Strawberry","Banana","Cherry","Pear"}&"*",B2:B6,">="&DATE(D12,B12,C12),B2:B6,"<="&DATE(D13,B13,C13)))
This worked great, but now I need to SUM the values of a column only if the specified names ARE NOT found in the cells, and if the dates of another column are between a certain range, kinda like the above formula.
Can anyone help me with this?
Bookmarks