Sumif

[tiredofit]

Assume I have a column of data:

100
200
300
400
500

How can I create a SUMIF to sum, such that if each value divided by 10 is less than 5?

Something like:

=SUMIF((A:A)/10,"<5",A:A)

Thanks

 

[FormR]

How can I create a SUMIF to sum, such that if each value divided by 10 is less than 5?

Hi, isn't that the same as saying they are less than 50?

=SUMIFS(A:A,A:A,"<50")

 

[tiredofit]

Yes it is.

However, if my formulae was more complicated, eg if the first condition is not to be divided by 10 but by column B (assuming I have data in column B), how would I approach that?

eg:

100     1
200     5
300     49
400     12
500     5

 

[RoryA]

You'd have to use SUMPRODUCT, not SUMIF.

 

[tiredofit]

Thanks