I need help writing a formula that sums up the values in column D if the following characteristics are true. The formula should be in D21.
If the value in column C is equal to "Long" and the value in Column F is less than 1 then add to sum. If the value in column C is equal to "Short" and the value in Column F is greater then 1then add to sum.
Last edited by rhudgins; 12-20-2010 at 05:02 PM.
Hi,
One way...
HTH
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks this works
How can I perform the same function but with countifs? I tried and I am recieving an error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks