“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to find which 1-3 entries from the DR column added together subtracting the sum of 1-3 CR columns added together will match $0.85.

Solved by A. J. in 28 mins

Hi, I am making a CF projection, & I need to sum numbers depending on a range or criterias:
Name of Vendor; Payment Status (Paid, Unpaid). That I can do using Sumifs. However, I need to sum up numbers provided that transaction relates only to month which have passed. For ex, I am making CF for the month of May and I only need to sum up unpaid amounts for Vendor 1 if they were to be paid before May (ie Jan, Feb, Mar, Apr). How to add that criteria to SUMIFS or any other formula?

Solved by C. E. in 14 mins

I have created a calendar to track expenses and i want to sum all values labeled Fuel. The calendar is monthly with 4 rows for each week. Fuel can show up on any day so the columns will vary but will always be in column 3,5,7,9,11,13,15.

Solved by A. H. in 20 mins

I want to have my month-to-date revenue calculated to project the whole month's revenue. SO if I am on the tenth day of the month I want the formula to sum the entries, divide by the number of entries (days completed, including zero if a day has zero sales) and multiply by the days in the month.
I can set a cell to the number of days in the month but how do I get it to divide only by the number of entries?

Solved by F. H. in 27 mins

I am trying to use the following formula to sum a column of six items if any item is nonzero but show nothing if they are all zero. If the first, second or sixth item is nonzero, it works. But if the those three are zero, the sum ignores the third, fourth, and fifth items. Here is the formula: =IF(N(F56)*N($J$2)+N(F57)*N($J$3)+N(F58)*N($J$4)+N(F59)*($J$5)+N(F60)*N($J$6)+N(F61)*N($J$7)=0,"",SUM(F56:F61))

Solved by C. Q. in 12 mins

Hello,
Having issues with a SUM formula.
I have a row of data C48:N48 that i need to SUM in sheet 'ABC Costing'
The data between C48:N48 is based on drop down menus from sheet 'Quote' so some cells are blank and some have values but this changes based on selections from the drop down menus.
What formula should I use in sheet 'ABC Costing' cell R48 to SUM C48:N48?

Solved by I. W. in 30 mins

i put a formula in a cell i want it to repeat by filling it down in the column but it keeps repeating the sum of the original number instead of recalculating the new row of numbers???

Solved by C. J. in 22 mins

Would like to be able to sum all tabs together per customer for example all the data for tabs.
Also would like to take those totals per month and get a yearly total

Solved by K. S. in 11 mins

I want excel to calculate a value between 2 date ranges that will always change,
So far i have the date ranged that change between years working fine
i have the start data and end date or each period working ( and changeing with the year, I,e the 15 to the 14 of every month) and i have the address of the start and end point, what i i cant not do is take the addess of the start cell [ c14] and [c 45] and use them in a sum function
=sum(c14:c45) as the c14 and c45 are only values in other cells ( based on address function)

Solved by A. A. in 21 mins

I'm using Excel Online for Outlook. I have a list set up so that the Sum of the numbers goes into a separate cell. However, half way down the list, it has stopped adding to the Sum. How do I fix this?

Solved by A. U. in 29 mins