Thread: SumIf equation question
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by LiziC View Post
Hi,

I'm using the below SumIf equation, however the range in Column G is a formula and so the sum always comes out to 0.

Is there a way to get the below forumla to only sum the values in H if the formula in G shows a value, and ignore anything cells in G that are blank?

(The formula in Column G is part of a IF equation with a VLOOKUP to a seperate spreadsheet)

=SUMIF(G25:G80,"<1",H25:H80)
Have you tried using =SUMIFS() rather than =SUMIF(). I think only available in 2007/2010. It allows more than one condition.

Or if using earlier than 2007 you could use =SUMPRODUCT() to do this for you.
Reply With QuoteReply With Quote