Calculate total of a column depending on month / years

**eAstro** · 12-28-2016, 09:01 PM

Hi,

i want to calculate total of a column depending on month / years

Ex: On Sheet 2016 C18 will show up the total of Nov 2016 in Sheet calcul column F

thanks

**TheN** · 12-28-2016, 09:47 PM

use your same formulas, but use sheet name followed by an ! to reference it.

Try typing =sum( then clicking to the calcul tab. It will give you the reference, then you can click the first cell, hold shift and select the last one. Same exact formula, just referencing a different page.

**eAstro** · 12-28-2016, 10:29 PM

Originally Posted by TheN

use your same formulas, but use sheet name followed by an ! to reference it.

Try typing =sum( then clicking to the calcul tab. It will give you the reference, then you can click the first cell, hold shift and select the last one. Same exact formula, just referencing a different page.

get a error on it

could you have a lookup

=SUMIFS(Boutique_1;Dates;">="&Calcul!A5;Dates;"<="&Calcul!A9)

or

=SUMIFS(Boutique_1;Dates;">="&DATE(2016;11;1);Dates;"<"&DATE(2016;11;30))

Calculate total of a column depending on month / years

LinkBack

Thread Tools

Rate This Thread

Display

Calculate total of a column depending on month / years

Re: Calculate total of a column depending on month / years

Re: Calculate total of a column depending on month / years

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add up the total amount of cash depending on the month?

Formulae (or VBA) count and total all entries in same month across different years

[SOLVED] Total of Years and Month Formula Needed, Please

How to calculate the total percentage of sales over several years in pivottable???

Calculate varying % of Total depending on total sum.

[SOLVED] Need formula to calculate total of different rates depending on count

[SOLVED] How to calculate sales total for a month from the dates (more than 5 years data)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions