Hi Guys
I'm using a sumif function but it doesn't seem to be working...
Column I in the Overview tab supposed to look at column U4 in the July tab and pull the figures from V4 in the July tab.
It's currently pulling figures from column AB of the July tab..
You are telling it to pull from what's in I$2 which is column 28 which is AB.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Your formulas in C2:I2 find the last numeric value in row 4 and then sum the column according.....but in July you have some extra columns, so as ChemistB says you get the numbers from column AB because that has the last numeric value in row 4.
If you want to always sum the column with the header "Monthly Average (Excl Saturday)" then try this formula in C2 copied across
=MATCH("Monthly Average (Excl Saturday)",INDIRECT(C1&"!$3:$3"),0)
alter E1 to remove the trailing space
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks