How to Sum first 12 cells in a row once a cell has data.

**andrebr** · 12-20-2023, 03:15 PM

I need help writing a formula to return the sum of the first 12 cells in a row once the first cell has data and regardless if the next 11 have data or not. I'm trying to obtain the first 12 months of revenue for each customer. I've been able to write a formula that sums the first 12 cells with data, but I need one that sums the first 12 regardless if subsequent months have data. So even if there is only 11 months of revenue in the first 12 calendar months for a customer I need to include the month with zero revenue. Thank you all for your help, I've been banging my head against the wall on this one.

**Estevaoba** · 12-20-2023, 03:28 PM

Welcome to the forum.

Please follow instructions on yellow banner above to upload a sample wb.

**Rick Rothstein** · 12-20-2023, 03:34 PM

Assuming the cells you are interested in are A1:L1 (change this in the formula to your actual range and change the A1 to the first cell of that actual range), try this formula...

=IF(A1="","",SUM(A1:L1))

**andrebr** · 12-20-2023, 03:51 PM

Thank you for the guidance I've attached a sample workbook. I'm looking to have the sum of the first 12 months in column BQ for the 5 "customer's" listed.

**andrebr** · 12-20-2023, 04:00 PM

Thank you Rick, the issue I'm running into is that I'm only trying to sum the first 12 rows of when data occurs. So in the sample workbook I would like to be able to sum the customers first 12 calendar months of revenue once it is greater than zero, but not sum anything after that for thousands of rows. Thank you again for the suggestion.

**cwayneu** · 12-20-2023, 04:11 PM

Alternatively, in case A1 is a blank and not NULL do this, otherwise a blank in A1 will trigger the SUM.

=if(ISNUMBER(A1),SUM(A1:L1),"")

**DJunqueira** · 12-20-2023, 04:16 PM

andrebr, your way to store data is not good, please think about storing it vertically as in the attached file and use Pivot Table to summarize it.

Attachment 853201

**Estevaoba** · 12-20-2023, 04:25 PM

Please try this in a blank cell of your choosing and drag down:

Formula:

Please Login or Register  to view this content.

Good luck!

How to Sum first 12 cells in a row once a cell has data.

LinkBack

Thread Tools

Rate This Thread

Display

How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Re: How to Sum first 12 cells in a row once a cell has data.

Thread Information

Users Browsing this Thread

Similar Threads

Help with functions to make cells calculate data or show blank cell based on other cells

Popukate a cell with data from several cells based on other cell data matching

Compare two cells, if equal move a third cells data to another cell

copy data from one cell to another dependant on the cells value between two other cells.

[SOLVED] Concatenate data in 2010, but only if both cells contain data and one cell's data isnt N/A

Copying cells after last cell, with out overwriting data in cells above.

Trying to format one cell to match data in two cells and input data from third cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions