[Solved] Want to use something like SUMIF

[swampwiz]

I have a Calc spreadsheet where there are values in columns A & B. I want to the SUMIF to check for a condition in row A, and if the condition is TRUE, then add in the value in the cell in corresponding row B, but not if FALSE.

So the function here would be like a SUM except that it would only add the values in the upper table if the A value there is <= the A value to the left of the function. I don't think that SUMIF does it like this.

•  A      B 

   00     234  
   07     188   
   14     069 

   00     234
   05     234
   10     422

[karolus]

I have a Calc spreadsheet where there are values in rows A & B. I want to the SUMIF to check for a condition in row A, and if the condition is TRUE, then add in the value in the cell in corresponding row B, but not if FALSE.

most people name it »Column« but you »Row« … maybe you should switch your mindset?

So the function here would be like a SUM except that it would only add the values in the upper table if the A value there is <= the A value to the left of the function. I don't think that SUMIF does it like this.

•  A      B 

   00     234  
   07     188   
   14     069 

   00     234
   05     234
   10     422

Code: Select all

=SUMIF(A$1:A$3;"<="&A10;B$1:B$3)

[swampwiz]

Yes, that was a brain fart on that sentence. I have updated it.

And this is a solution that works perfectly!