Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Last Months Data!!
I am trying to auto populate a cell with sum of users for last month:
Column A Column B Month No of Users I have managed to calculate, this weeks, last weeks and the last 30 days total of users using a variation of: =SUMIF(A1:A100, "="&TODAY()-7, B1:B100) I want to be able to see the last calender month total. So today I would get the total number of users for November. I have tried adding the MONTH function but the SUMIF function does like all the arguments needed to calculate the what last month was. Any help would be appreciated. - Jeff |
#3
|
|||
|
|||
Try
=SUMPRODUCT(--(MONTH(A1:A100)=MONTH(TODAY())-1),B1:B100) "Jeff" wrote in message ... I am trying to auto populate a cell with sum of users for last month: Column A Column B Month No of Users I have managed to calculate, this weeks, last weeks and the last 30 days total of users using a variation of: =SUMIF(A1:A100, "="&TODAY()-7, B1:B100) I want to be able to see the last calender month total. So today I would get the total number of users for November. I have tried adding the MONTH function but the SUMIF function does like all the arguments needed to calculate the what last month was. Any help would be appreciated. - Jeff |
#4
|
|||
|
|||
You can do it easier by using sumproduct and MONTH but if you want to use
SUMIF you would need something like =SUMIF(A1:A100, "="&DATE(YEAR(TODAY()),MONTH(TODAY())-1,1), B1:B100)-SUMIF(A1:A100, ""&DATE(YEAR(TODAY()),MONTH(TODAY()),0), B1:B100) Regards, Peo Sjoblom "Jeff" wrote: I am trying to auto populate a cell with sum of users for last month: Column A Column B Month No of Users I have managed to calculate, this weeks, last weeks and the last 30 days total of users using a variation of: =SUMIF(A1:A100, "="&TODAY()-7, B1:B100) I want to be able to see the last calender month total. So today I would get the total number of users for November. I have tried adding the MONTH function but the SUMIF function does like all the arguments needed to calculate the what last month was. Any help would be appreciated. - Jeff |
#5
|
|||
|
|||
Thanks for the help.
"Dave R." wrote: Try =SUMPRODUCT(--(MONTH(A1:A100)=MONTH(TODAY())-1),B1:B100) "Jeff" wrote in message ... I am trying to auto populate a cell with sum of users for last month: Column A Column B Month No of Users I have managed to calculate, this weeks, last weeks and the last 30 days total of users using a variation of: =SUMIF(A1:A100, "="&TODAY()-7, B1:B100) I want to be able to see the last calender month total. So today I would get the total number of users for November. I have tried adding the MONTH function but the SUMIF function does like all the arguments needed to calculate the what last month was. Any help would be appreciated. - Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Weekly data allocated to months | Excel Worksheet Functions | |||
Weekly data allocated to months | Excel Worksheet Functions |