Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Sum by Month

Hello,

I am having an issue with summing data from another sheet.
It works fine if the data is on the same sheet.

Do you see where I have made a mistake?

thank you
EE-SumIF-Dates.xlsx
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Have you set the data like that or is an import? You could achieve this more efficiently by using a PivotTable if the data was arranged correctly.
Avatar of pdvsa

ASKER

HI Roy, I wish I could use a pivot but the original data set is not in the correct form.  What I uploaded was pieces from the original.  I would like to be able to sum per month and reference the data from the other sheet.  I would like to reference data from teh other sheet to avoid the summary sheet having too much information.
I thought that must be the case. Is there no way to re-format the data? Maybe, just copy and pastespecial - transpose.
Avatar of pdvsa

ASKER

Maybe so.  
Let me know what you think about summing the data from another sheet.

thank you
Have you tried SUMIFS instead of SUMPRODUCT?
Avatar of pdvsa

ASKER

I have not...not sure how I would do that considering the data is on the other sheet.
I've just tried and the SUMIFS works fine on the same sheet, but not with the other sheet. I'll try to find out why.
Avatar of pdvsa

ASKER

I just tried too and I think the range and the sum range need to be on the same sheet.  The month you are referring to (criteria) for the sum can be on the sheet with the formula.

sumif(range,criteria, [sum range])
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This is really strange. It works perfectly when the data is arranged vertically. Note I changed the criteria to an actual date and formatted it "mmmm" on the Data Test Sheet, I prefere when working with dates to actually use real dates.
EE-SumIF-Dates--1-.xlsx
Avatar of pdvsa

ASKER

thank you once again.
You're welcome. Glad to help.