DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 176
- Office Version
- 365
- Platform
- Windows
I am looking to create a formula using both the sumf and countif operators.
Example, Column A contains store numbers. Column D contains deposit variances(positive and negative numbers).
However, there is an entry for every store, every day, even if there is no variance
So, what I am try to accomplish is the following:
If the store number is 1, how many times how many times is the variance <>0
The not working version of this formula would be something like =SUMIF(A:A,A2,countif(D:D<>0))
I know that that doesn't work.
To further complicate the formula, we have a tab for each month of the year, so for February's entry, it might look something like this (again, this doesn't work):
=SUMIF('FEB 2016'!A:A,A2,"countif('FEB 2016'!D:D<>))
Is there an easy way to do this?
Example, Column A contains store numbers. Column D contains deposit variances(positive and negative numbers).
However, there is an entry for every store, every day, even if there is no variance
So, what I am try to accomplish is the following:
If the store number is 1, how many times how many times is the variance <>0
The not working version of this formula would be something like =SUMIF(A:A,A2,countif(D:D<>0))
I know that that doesn't work.
To further complicate the formula, we have a tab for each month of the year, so for February's entry, it might look something like this (again, this doesn't work):
=SUMIF('FEB 2016'!A:A,A2,"countif('FEB 2016'!D:D<>))
Is there an easy way to do this?