LinkBack URL
About LinkBacks
Hi
In G7 and copy down and across.
=SUMPRODUCT((B!$D$6:$D$26=A!$B7)*(B!$B$6:$B$26=A!$C7)*(B!$C$6:$C$26=A!$D7)*(B!F$6:F$26))
This will gives you the numbers per year.
We can not do this by month because we don't know the months...
Hi
In G7 and copy down and across.
=SUMPRODUCT((B!$D$6:$D$26=A!$B7)*(B!$B$6:$B$26=A!$C7)*(B!$C$6:$C$26=A!$D7)*(B!F$6:F$26))
This will gives you the numbers per year.
We can not do this by month because we don't know the months...
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you for your response - I have attached a slightly more realistic example with an intro into the sumif that I am using.
Wondering if there is a more efficient way than just doing several IF Functions by year.
THANKS!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks