Link to home
Start Free TrialLog in
Avatar of agwalsh
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
SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hahaha @ Rory...good one...didn't thought about that.. Ouch...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Well spotted - thanks, Rob.
Avatar of agwalsh
agwalsh

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...