Im trying to sum a column if the value is positive and only if a second column has a specific word. I tried the following:
SUMIF(D4:D3539,"*House",C4:C3539) and D4:D3539 >0
This didnt work. Need help. Thanks
Im trying to sum a column if the value is positive and only if a second column has a specific word. I tried the following:
SUMIF(D4:D3539,"*House",C4:C3539) and D4:D3539 >0
This didnt work. Need help. Thanks
Last edited by pike; 06-12-2011 at 07:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks