Sumifs formula or any other formula to arrive at number

[vasudev_kamat]

Hi Friends,

I am using Sumif formula to sum the total number. My example formula is as follows.
=SUMIFS($V$115:$V$98999,$U$115:$U$98999,"Not Due",$C$115:$C$98999,"9333")

In this above formula value is calculated if in specific range U amount is 'not due' and number is 9333, I want to add one more condition in sumifs. Say I want to also consider another number with only 4 digit values, it should create the sum. Particular row has different numbers like 325000, 438000, 3455, 7843

 

[KOKOSEK]

4 digits values means 999 < X < 10000, so:

=SUMIFS($V$115:$V$98999,$U$115:$U$98999,"Not Due",$C$115:$C$98999,"9333",$V$115:$V$98999,"<10000",$V$115:$V$98999,">999")

 

[vasudev_kamat]

Hi Kokosek , Thanks for the support. It is really out of box.. Although it seems simple, one who get that idea must be really smart

 

[KOKOSEK]

Happy to help.

 

[vasudev_kamat]

Hi Guyz, I need one more help. Now 4 digit value showing Alpha Numberic like 4b28, 392c etc, hence forumula is not considering. Anyone help please.