LinkBack URL
About LinkBacks
Hi-
Can I add 2 sumifs, because it isn't picking up the part after the plus sign.
Please Login or Register to view this content.
Hi-
Can I add 2 sumifs, because it isn't picking up the part after the plus sign.
Please Login or Register to view this content.
It is correct syntax. May you provide example of what is incorrect?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There's nothing wrong with the formula although you could just use SUMIF.Originally Posted by cartica
If the 2nd SUMIFS is returning 0 but you think it should return something else then there may be a data problem.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks, I see why it wasn't returning a value, i was taking a number already being divided by 1M, and then this divided it again.
Is there a way to change the second half of my formula to include that I want to add the sumif if $ag$21:$ag$26 is less than 0, but subtract if greater than 0?
Thank you
Just take the absolute value of the SUMIFS and then subtract it.
Please Login or Register to view this content.
That works thanks everyone.
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks