# Amalgamate Multiple SUMIFS Statements Into One

1. ## Amalgamate Multiple SUMIFS Statements Into One

Hi All,

The problem in question is shown in the sample file attached. For the dates in September 2014, tasks were undertaken on certain days including weekends (highlighted) and the time spent on the task is recorded in column D. Column B is a sime TEXT function that identifys the day of the week against a particular date.

I need to sum all the times for weekend days. I could do this using two SUMIF statements to identify Saturday and Sunday and add them together [SUMIF(B3:D32,"Saturday",D3:D32)+SUMIF(B3:D32,"Sunday",D3:D32)] shown in cell H4.

However, when it comes to summing times for weekdays I'd need five SUMIFS to identify Monday, Tuesday, etc and then add them up which is getting cumbersome.

I'm wondering if anyone knows if it's possible to amalgamate multiple SUMIF statements into one single cleaner statement that will do the same job for weekend days and weekdays or if there is an alternative function that will achieve this.

Many thanks

2. ## Re: Amalgamate Multiple SUMIFS Statements Into One

=SUM(SUMIF(B3:D32,{"Saturday";"Sunday"},D3:D32))
Try this

3. ## Re: Amalgamate Multiple SUMIFS Statements Into One

Fantastic! Works a treat!

Thank you so much!

4. ## Re: Amalgamate Multiple SUMIFS Statements Into One

You are welcome and thanks for your feedback

5. ## Re: Amalgamate Multiple SUMIFS Statements Into One

hi, TRY

Formula:
`Please Login or Register  to view this content.`

6. ## Re: Amalgamate Multiple SUMIFS Statements Into One

For weekends use this:

Formula:
`Please Login or Register  to view this content.`

For weekdays, use this:
Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1