Hi everyone.
I want to say =SUMIFS($E4:$AI4,E5:AI5,"DM"OR"DY")
Can't get the OR part to work. Any ideas? It works the way I have it in the title but I'd like to learn how to shorten it.
Thanks in advance for any help!
Hi everyone.
I want to say =SUMIFS($E4:$AI4,E5:AI5,"DM"OR"DY")
Can't get the OR part to work. Any ideas? It works the way I have it in the title but I'd like to learn how to shorten it.
Thanks in advance for any help!
Try
=SUM(SUMIF(E5:AI5,{"DM","DY"},$E4:$AI4))
calebk2001,
Give this a try:
=SUM(SUMIFS($E4:$AI4,E5:AI5,{"DM","DY"}))
[EDIT]:
Looks like I got beat to it by Jonmo1, and his is backwards compatible
Last edited by tigeravatar; 07-08-2013 at 01:35 PM. Reason: added edit
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks guys! That's just exactalactly what I needed
You're welcome.
Another possibility...
If those are the only 2 letter entries that start with the letter D:
=SUMIF(E5:AI5,"D?",E4:AI4)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks