put in each column and detect in each of the 3 groups and add.

**jorel** · 01-28-2023, 11:33 AM

put in each column and detect in each of the 3 groups and add,
the numbers 06 12 18 24, appear in the two groups of multiples of 2 and 3, no problem, detect even with the double numbers in the multiples to add
https://www.excelforum.com/attachmen...1&d=1674920022

**JohnTopley** · 01-28-2023, 12:21 PM

in W5

=SUMPRODUCT(--(MOD($A5:$O5,2)=0)*($A5:$O5))

in AC5

=SUMPRODUCT(--(MOD($A5:$O5,3)=0)*($A5:$O5))

in AN5

=SUMPRODUCT(--(ISNUMBER(MATCH($A5:$O5,AE$4:AL$4,0)))*($A5:$O5))

**jorel** · 01-29-2023, 03:13 PM

of the sum ok the part, but it has to show which in each group the first two groups have to line up in the columns

**JohnTopley** · 01-29-2023, 03:29 PM

Please Login or Register  to view this content.

=MOD_2($A5:$O5)

=MOD_3($A5:$O5)

**JohnTopley** · 01-29-2023, 03:35 PM

In Ae5

=COUNTIF($A5:$O5,AE$4)

Copy across and down

put in each column and detect in each of the 3 groups and add.

LinkBack

Thread Tools

Rate This Thread

Display

put in each column and detect in each of the 3 groups and add.

Re: put in each column and detect in each of the 3 groups and add.

Re: put in each column and detect in each of the 3 groups and add.

Re: put in each column and detect in each of the 3 groups and add.

Re: put in each column and detect in each of the 3 groups and add.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Challenging issue: Detect Outliers in a Column with multiple groups of data

[SOLVED] detect the corresponding groups from the draw list.

[SOLVED] convert in the three possible pairs and then detect in the three groups.

detect in each of the 4 groups * the amount of times of each digit,

[SOLVED] detect and add the quantities of letters in their groups

please, detect on each pair, * one of the 7 groups.

[SOLVED] Using VBA to detect separate groups of rows.

Bookmarks

Bookmarks

Posting Permissions