SUMIF - double variable

  • Thread starter Thread starter Roman
  • Start date Start date
R

Roman

is there a way to perform a sumif function with a double
variable?

i.e., i want the total value of column H as long as the
value in column A="CORP" AND the value in column D>0.

i tried several combinations but have had no luck.

I hope you folks could help, my IT dept lacks basic skills

:(

Thanx
 
Roman,

Use the SUMPRODUCT function. E.g.,

=SUMPRODUCT((A1:A10="CORP")*(D1:D10>0))

The multiplication operator * works like a logical AND because it returns
true (=1) only when both operands are true.
 
the SUMPRODUCT function seems to be working as a COUNTIF.
counting everytime the amount in column D is greater
than "0" when the value in column A is "CORP".

what I am trying to do is sum the values in a third
column, say column H, for every instance the value in
column A = "CORP" AND the amount in column D is ">0".

the formula that I ultimately want is a combination of:

=SUMIF(A:A,"CORP",H:H)
=SUMIF(D:D,">0",H:H)

kind of =SUMIF(AND(A:A="CORP",D:D>0),H:H)

please help if you can

Roman
 
a version of that formula worked perfectly. Thank you.

would I be able to throw in a 3rd criteria, e.i., account
number in column B = "12345"?

would appreciate it.

Roman
 
Roman,

You can add as many conditions as you want. E.g.,

=SUMPRODUCT((A1:A10="CORP")*(B1:B10=12345)*(D1:D10>0)*H1:H10)
 
Back
Top