Thread: How to refer to a criterie in a cell using excel sum.if function
View Single Post
  #1   Report Post  
RuneVSP RuneVSP is offline
Junior Member
  
Posts: 6
Default How to refer to a criterie in a cell using excel sum.if function
Hi i cant figure out how to makte this happen.

i have added the following

=SUM.IF(A17:A21;"<5";B17:B21)

which Work perfectly fine, the problem is that i would like to have a cell reference (B14)instead of 5 but i dont know how to make it Work.

my best guess is

=SUM.HVIS(A17:A21;"B14";B17:B21)

what am i doing wrong?
Last edited by RuneVSP : November 13th 13 at 10:18 AM
Reply With QuoteReply With Quote