For earlier versions, use this adpatation of Colin's formula
![]()
=SUMPRODUCT(E3:E782,--(ISERROR(SEARCH("U.S. Treasury",D3:D782))),--(ISERROR(SEARCH("Fed",D3:D782))))
For earlier versions, use this adpatation of Colin's formula
![]()
=SUMPRODUCT(E3:E782,--(ISERROR(SEARCH("U.S. Treasury",D3:D782))),--(ISERROR(SEARCH("Fed",D3:D782))))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks