Windows 10: Sumifs function worked well till I included one more criteria, then it give "value"

Sumifs function worked well till I included one more criteria, then it give "value"

:)

 

Formula to SUM values in mulitple columns, based on criteria from another column

You will want to use SUMIFS for this.

The first part =SUMIFS(B2:B8,A2:A8,">="&3000,A2:A8,"<="&3999) will sum up any values in B2:B8, where the value in A2:A8 is greater than or equal to 3000, and where the value is ALSO less than or equal to 3999.

The second part +SUMIFS(C2:C8,A2:A8,">="&3000,A2:A8,"<="&3999) Then does the same but sums up form C2:C8.

 

Overclocking / Undervolting guide for Vega 56 or 64?

Here's a quick laundry list:

List of software to use for overclocking and testing
Examples:
Wattman (and how to find and use it, like an overview, including profiles)
Unigine Valley or Heaven (use this for quick testing while changing settings in Wattman and checking for stability / artifacts) ...just suggesting this
How to monitor cores / mem speeds and temps during testing (I've seen screen overlays, and others using GPUz)

Step-by step overclocking in Wattman
Fan speeds
Power limit
Temp limit
Voltages
Core speeds
Memory speeds

 

Lotus 123

I'm successfully running 123 on w10 but also use excel.

1) Is there a similar function to sumifs in 123?

2) Is there a help out there that lists ALL 123 functions with examples? The help in my 123 doesn't work!

3) I can't remember how to express the >= in following equation: @SUMIF($AU$2..BF$2,BR1,$AU6..BF6) which correctly allows me to sum the range AU6- BF6 IF AU2-BF2 is EQUAL to the contents of BR1 but I want it to SUM all that's GREATER or EQUAL. Tried following
two different ways of expressing formulae but doesn't work:

@SUMIF($AU$2..BF$2,>=BR1,$AU6..BF6) and @SUMIF($AU$2..BF$2,">="BR1,$AU6..BF6).

I do know that if I embed the actual contents (ie 'xxx') of BR1 in the formula then it works like this:

@SUMIF($AU$2..BF$2,">=xxx",$AU6..BF6)

I'm missing something simple! Can anyone help?