Using =Sumifs(Sheet1!A10:M10,'Sheet1!A7:M:7,">"&'SheetA'$B$3)
It's bringing back zero's.
Sheet 1 A10 to M10 is the range of data I need summed
If Sheet 1 A7 to M7 (are months Jan-Dec)is a greater date then what's in
Sheet A cell B3 which is the input tab.
Help Please
Thank you-
Last edited by TreeLife; 08-25-2016 at 08:28 PM.
Try
=Sumifs('Sheet1'!A10:M10,'Sheet1'!A7:M10,">"&'SheetA'!$B$3)
Last edited by Glenn Kennedy; 08-25-2016 at 03:40 PM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you for replying. That is what I have currently. I was unable to copy paste and hand typed the formula. I do have the accents/exclamation etc.
ETA... it is working now. I had to change the months to dates in numbers in the date range.
Last edited by TreeLife; 08-25-2016 at 04:08 PM.
Are they the month names as TEXT entries or are they dates?Originally Posted by TreeLife
What's in 'SheetA'!$B$3? Be specific!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
In SheetA'$B$3, there was the date 6/30/2016 formatted to Jun-16
In Sheet1 A7:M7 the referenced cells were Month Names in TEXT. I changed them to "dates" like SheetA and the formula worked.
This is the correct way the formula should look in the cell (for any other Forum Members searching this thread)
Thanks!
Good deal. Thanks for the feedback!
Glad to have helped & thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks