Hi,
I have a list of projects and their income per month, as attached. I would like a formula that shows the sum of values where the figure has increased from column K to column L (red cells), and also where they have decreased (yellow cells).
Does anyone have any advice?
Thanks
rich
=SUMPRODUCT(($H$4:$H$71>$G$4:$G$71)*$H$4:$H$71)
and
=SUMPRODUCT(($H$4:$H$71<$G$4:$G$71)*$H$4:$H$71)
oughta do it
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank for the reply. I am trying to show the difference though, which I can see is not what my original question stated, so apologies for that.
Can I adjust this formula to give the difference?
sure
=SUMPRODUCT(($H$4:$H$71>$G$4:$G$71)*($H$4:$H$71-$G$4:$G$71))
and then use < for the other one :-)
That's perfect, thank you very much.
You've helped me take a substantial chunk out of a process and speed the whole thing up, which is the aim of the game!
you're welcome :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks