Is it possible to sum the value in the column from only the first five cells with content

**Kjerti05** · 01-22-2018, 11:03 AM

Hi,

Is it possible to sum the value from only the first five cells in the each of the two column "used" (Green colour) after the registered values in column "Recevied" in the attached sheet?

Regards,
Kersti08

**davsth** · 01-22-2018, 11:29 AM

Perhaps

=SUM(OFFSET(C4,MATCH(TRUE,INDEX((B5:B50<>0),0),0),0,5,1))

although you may use ; instead of ,

Is it possible to sum the value in the column from only the first five cells with content

LinkBack

Thread Tools

Rate This Thread

Display

Is it possible to sum the value in the column from only the first five cells with content

Re: Is it possible to sum the value in the column from only the first five cells with cont

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Is it possible to sum the value in the column from only the first five cells with content?

[SOLVED] Delete Cells In Column With Content

[SOLVED] For highlighting superscript content cells in a column.

For highlighting superscript content cells in a column.

[SOLVED] Sum cells in a column, based on content of another column.

[SOLVED] How can I use VBA to delete cells that don't have content in column B for rows 4 and below

Copying Bold content cells down the column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions