Calculate entered data only if another cell has data in

[DJMorgan]

Hi

I'm using a spreadsheet that shows our this weekly sales vs this week last year, day by day for the week. Its a basic sheet but with many different sites it has a lot of information in it

• At the beginning of the week we enter every days sales for last year and a simple calculation adds up the total for the whole week eg £10k per day so £70k for the whole week
• As the week progresses we enter this years sales in, day by day. Again, a simple calculation adds this up

What I need is for the last years sales to only calculate up to what day, this year, has data in it. So for example if it is Wednesday, I only want Mon, Tue and Weds last years total figure to calculate,

(£30k),​

ignoring the rest of the week (£40k) because there are no figures in this years cells. Can this be done relatively easily?

Many thanks in advance

 

[jtakw]

Hi,

Without any sample data, I can only suggest looking into SUMIF and SUMIFS:

https://support.office.com/en-us/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b

https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b

 

[DJMorgan]

Thank you for the links, they were very helpful

 

[jtakw]

You're welcome, welcome to the forum, hope you get it sorted out.