agwalsh
asked on
sumifs for cumulative - more elegant way?
hi Folks
I'm working on a way to generate year to date numbers and I've come up with a way using sumifs but it seems very long winded to me and I was wondering if there was a less clunky way to do it than the way I am doing...I don't want to go into a VBA solution to be honest...I'm just curious about a more streamlined way to do it...the one I'm curious about is in the Cumulative Spend sheet...
EE-sumifs-procurement-mtd-ytd-spend.xlsx
I'm working on a way to generate year to date numbers and I've come up with a way using sumifs but it seems very long winded to me and I was wondering if there was a less clunky way to do it than the way I am doing...I don't want to go into a VBA solution to be honest...I'm just curious about a more streamlined way to do it...the one I'm curious about is in the Cumulative Spend sheet...
EE-sumifs-procurement-mtd-ytd-spend.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hahaha @ Rory...good one...didn't thought about that.. Ouch...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well spotted - thanks, Rob.
ASKER
Sigh, you people...just f***** amazing..went with =SUMIF($B$2:E$2,"<>*YTD",$ B3:D3) . Had to tweak it a tiny tiny bit. Thank you all so much..I KNEW there was a more elegant solution than what I had out there.. and of course you proved me right...