Difficult Count if or Sum if problem

**m_carter** · 07-02-2019, 03:46 AM

Hi,
I have a 'calendar' sheet where a "1" is inserted following certain rules, the cell will have either one or zero. It is a calendar sheet so it will have days of the week (both with dates and name).
The sheet cannot be changed format as it is needed for some reporting.
We have to be able to add a column / calculation at the end of the calendar to show "instances" This means if = 1 and previous cell is = 0 then count/sum, if =1 but previous cell is also = 1 then don't count / sum. If cell is = 0 don't count/sum.

Is there any formula I can use for this?

**AliGW** · 07-02-2019, 03:59 AM

In P3 copied down:

=COUNTIFS($B3:$O3,1,$A3:$N3,0)+IF(B3=1,1,0)

**m_carter** · 07-02-2019, 04:09 AM

Thank you so much, i'll give it a go with the real data but it seems to work well

**AliGW** · 07-02-2019, 04:12 AM

Well, as long as your real data is in the same format, there shouldn't be a problem. Of course, if, as many do, you've forgotten something critical, don't be surprised if it doesn't.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**Pepe Le Mokko** · 07-02-2019, 06:32 AM

And to get back to basics we can also use this variation =COUNTIFS($B3:$O3,1,$A3:$N3,0)+--(B3=1)

Difficult Count if or Sum if problem

LinkBack

Thread Tools

Rate This Thread

Display

Difficult Count if or Sum if problem

Re: Difficult Count if or Sum if problem

Re: Difficult Count if or Sum if problem

Re: Difficult Count if or Sum if problem

Re: Difficult Count if or Sum if problem

Thread Information

Users Browsing this Thread

Similar Threads

Count duplicates very difficult.

Difficult sort problem

Difficult V Look up and if function together problem

a difficult problem

A Difficult Unconcatinate Problem

Difficult Excel Problem

Difficult PrintTitleRows problem

Bookmarks

Bookmarks

Posting Permissions