ExcelBanter - How do I use Sumif and have the criteria be 10 AND <26?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I use Sumif and have the criteria be 10 AND <26? (https://www.excelbanter.com/excel-discussion-misc-queries/163533-how-do-i-use-sumif-have-criteria-10-26-a.html)

Jose

How do I use Sumif and have the criteria be 10 AND <26?

I have seen some sumproduct solutions, but unfortunately, I did not write
them down.
--
I need so much help, but right now, some Excel help will suffice!!

Peo Sjoblom

How do I use Sumif and have the criteria be 10 AND <26?

=SUMIF(A1:A50,"10")-SUMIF(A1:A50,"=26")

or

=SUMPRODUCT(--(A1:A5010),--(A1:A50<26),A1:A50)

the first formula is more efficient
--

Regards,

Peo Sjoblom

"Jose" wrote in message
...
I have seen some sumproduct solutions, but unfortunately, I did not write
them down.
--
I need so much help, but right now, some Excel help will suffice!!

Jose

How do I use Sumif and have the criteria be 10 AND <26?

THANK YOU!!!!
--
I need so much help, but right now, some Excel help will suffice!!

"Peo Sjoblom" wrote:

=SUMIF(A1:A50,"10")-SUMIF(A1:A50,"=26")

or

=SUMPRODUCT(--(A1:A5010),--(A1:A50<26),A1:A50)

the first formula is more efficient
--

Regards,

Peo Sjoblom

"Jose" wrote in message
...
I have seen some sumproduct solutions, but unfortunately, I did not write
them down.
--
I need so much help, but right now, some Excel help will suffice!!

All times are GMT +1. The time now is 05:09 AM.