Hi Everyone,
Please help!!
Is it possible to pass two (2) separate "criteria" (the second argument) in the SUMIF function?
For example, I have the following in my worksheet:
- in B17:B28, I have some data
- in E17:C28, I have some other data
- in J17:D28, I have the numbers to be summed up
- I would like to use the SUMIF function to SUM up the range J17:J28 based on the criteria in range B:17:B28 and E17:E28. More to the point, the function would sum only if the criteria in B17:B28 and E17:E28 matched.
note: this gets tricky because you also have to pass these criteria through the "range" argument in the SUMIF function
Is this even possible?
If it's not possible using the SUMIF formula directly, can someone please suggest some VBA code that might do the trick??
Thank you!
Rachel
Please help!!
Is it possible to pass two (2) separate "criteria" (the second argument) in the SUMIF function?
For example, I have the following in my worksheet:
- in B17:B28, I have some data
- in E17:C28, I have some other data
- in J17:D28, I have the numbers to be summed up
- I would like to use the SUMIF function to SUM up the range J17:J28 based on the criteria in range B:17:B28 and E17:E28. More to the point, the function would sum only if the criteria in B17:B28 and E17:E28 matched.
note: this gets tricky because you also have to pass these criteria through the "range" argument in the SUMIF function
Is this even possible?
If it's not possible using the SUMIF formula directly, can someone please suggest some VBA code that might do the trick??
Thank you!
Rachel