LinkBack URL
About LinkBacks
Im trying to get a sumifs working but im having trouble when i need it to look left to right and up and down within the same formula
If you are a sumifs wizard please see attached
I hope someone can help!! :0
Im trying to get a sumifs working but im having trouble when i need it to look left to right and up and down within the same formula
If you are a sumifs wizard please see attached
I hope someone can help!! :0
Try:
=SUMIF(A6:A48,O2,INDEX(B6:M48,0,MATCH(N2,B5:M5,0)))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi NBVC,
Thank you for your reply, I doesnt seem to sum when the dates are changed. so if it was ML and the date was 12/08/13 - 14/08/13 i would need it to add between them dates ... can it be done?
Try:
=SUMIFS(INDEX(B6:M48,0,MATCH(N2,B5:M5,0)),A6:A48,">="&O2,A6:A48,"<="&Q2)
I think that this should do what you want.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks