whimper | whimper is an example of purposeful testing with Jest | Frontend Framework library

Clean up your code, kiddies. After much wailing and gnashing of teeth, the problem turned out to be the extra parentheses I had in my .Sum arguments. Big thanks to @BigBen and @JvdV.

The Problem: Worksheetfunction.Sum returns a sum of 0 for a dynamic range, but only for rows.count > 1 and only for currency-formatted reference data.

More Detail: I have a userform set up to scrape a reference workbook and return a different number into each of four different textboxes based on user input. On occasion the numbers will need to be a sum of several rows on the reference workbook. Using my code below, this works like a dream for every return textbox as long as the number of rows is 1, but returns 0 (or $0.00 as it were) for anything else. However, it works just fine in all circumstances for the one sum that is just an integer. The rest are formatted as currency.

What I've done: Using MsgBoxes I've verified that the dynamic range returns the correct addresses, i.e. all cells I want summed and that the numbers at those addresses are in fact numbers and not text (verified by a True return for IsNumber). I've tried using .Subtotal and .Aggregate to see if those might help, but I ran into Missing Object and other errors and ran away whimpering because I'm new to VBA.

The Code:

My basic logic is as follows: Search in every sheet of the reference (csrWorkbook) for textbox.value. Once found, measure the height of the merged area (I know I know, but the merging decision is made above my paygrade). Offset to the right to find 4 different related quantities. Sum these quantities if multiple rows exist. Return the sum to four different textboxes.

Help!

When I attempted to compile the following Java program:

I have default template which is looks like this

when i add my loop it becomes like this

As you see in second image padding and margins are not as same as default one but html output looks fine

This is an odd one. I'm not sure it's the right place to ask, but maybe there are some sound experts who can chime in? (no pun intended)

We use two sounds on our website to indicate success and failure on a quiz. Those are very simple and short sounds.

Somehow one of our customers reported that her dog was whimpering and really upset with both of those sounds. He's normally fine with lots of other sounds that dogs are typically unhappy with including loud sounds, hoovers etc. She even said it happens when she uses headphones!

Other than muting, or replacing those sounds (and upsetting other dogs?), is there anything we can do to clean the sound or detect what specifically makes them upset this or other dogs?

Downvoters: I think this question crosses over between biology/physiology/physics and signal and audio processing. The answers I'm getting now actually demonstrate this. It requires this cross-domain knowledge. In any case, I'm happy to delete it if this seems to not jive well with this community. I think my intentions were positive and I added a bounty to try to solve this real problem. It saddens me to even see downvotes for the answers although they made an effort to help.

EDIT: I'm unable to delete this question it seems. I get an error message.

EDIT2: In case it's more helpful, here's a spectrum analysis of both sounds using Audacity. There are lots of different options, but this is using the default options for Analyze->Plot spectrum

I have a dataset