Thread: How to refer to a criterie in a cell using excel sum.if function
View Single Post
  #2   Report Post  
Kevin@Radstock Kevin@Radstock is offline
Member
  
Posts: 93
Default
Quote:
Originally Posted by RuneVSP View Post
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?
Maybe!

=SUMIF(A17:A21;"<"&B14;B17:B21)
Reply With QuoteReply With Quote