Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. =СУММЕСЛИМН(C:C;B:B;">=01.12.17";B:B;"<=31.12.17")
  2.  
  3. =СУММЕСЛИМН(C:C;B:B;">="&A1;B:B;"<="&A2)
  4.  
  5. =СУММПРОИЗВ(C2:C10;--(B2:B10>=A1);--(B2:B10<=A2))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement