The problem I'm encountering today is matching and summing values based on a condition.
Please see attached workbook and screen Capture.
The problem I'm encountering today is matching and summing values based on a condition.
Please see attached workbook and screen Capture.
TRY
=SUMPRODUCT(($N$3:$N$23)*($L$3:$L$23=$A3)*(ISNUMBER(SEARCH("pipe",$M$3:$M$23))))
=SUMPRODUCT(($N$3:$N$23)*($L$3:$L$23=$A3)*(ISNUMBER(SEARCH("90",$M$3:$M$23))))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Remove the quotes from "Pipe" and "90" and use this in F3:
See attached.Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Another option, after removing the quotes from Pipe & 90Formula:Please Login or Register to view this content.
SOLVED. Thank you so much for the help!
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks