Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

**calebk2001** · 07-08-2013, 01:29 PM

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!

**Jonmo1** · 07-08-2013, 01:32 PM

Try

=SUM(SUMIF(E5:AI5,{"DM","DY"},$E4:$AI4))

**tigeravatar** · 07-08-2013, 01:34 PM

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

**calebk2001** · 07-08-2013, 01:45 PM

Thanks guys! That's just exactalactly what I needed

**Jonmo1** · 07-08-2013, 01:47 PM

You're welcome.

**Tony Valko** · 07-08-2013, 02:25 PM

Another possibility...

If those are the only 2 letter entries that start with the letter D:

=SUMIF(E5:AI5,"D?",E4:AI4)

Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

LinkBack

Thread Tools

Rate This Thread

Display

Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

Re: Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

Re: Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

Re: Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

Re: Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

Re: Shorten this? =SUM(SUMIFS($E4:$AI4,E5:AI5,"DM")+(SUMIFS($E4:$AI4,E5:AI5,"DY")))

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions