Sumproduct across multiple sheets or rows

[Matt1993]

Hi all,

First time posting.

Having a nightmare with "Sumproduct"

I've created a spreadsheet for my company that monitors annual leave and sickness. I have a total number of sickness days, as well as a sumproduct formula to work out occasions of sickness- =SUMPRODUCT(--(B10:AF10=1),--(C10:AG10<>1))

I've realised that I need this to run onto the next tab, which is the next month April-May. How do I link the rows to carry on into the next tab?

Any help is much appreciated!!

 

[cyrilbrd]

Hi,
Just an observation.
Your data looks like it is ready for printing.
Maybe you would consider organizing your raw data into a table as to create a database that could be extracted with either formulae of pivot tables or any other type of query.
Such would eventually make your work easier.