Search results

Kyle, once again you have saved me so much time and frustration. The formula works perfect. You helped more than you know. Thank you......

Kyle was kind enough to help me with the correct formula as follows: =SUMPRODUCT(SUMIF(INDIRECT(ROW($A$1:$A$31)&"!B4:B13"),"DEANS",INDIRECT(ROW($A$1:$A$31)&"!C4:C13"))) It works perfectly. Now instead of working with range of cells, I need to "Countif" single cells across 31 pages on one...

Kyle, that formula works perfect. I finished my summary spread sheet this morning. 14 hours down to about 30 min. Thank you.

I'll try it at work tomorrow. If that works you will have saved me about 14 hours of work. Thanks.

Hello, my name is Tony. I manage an excavation company and I thought that was difficult. I have a lot of respect for the amount of knowledge evident here. I'll do my best to keep up.

I stumbled upon this site and had to sign up. Great members and topics. I have 31 (days of the month) pages and one Summary page. The following formula works just fine for one single page. =sumproduct(sumif(Indirect(''''''&1&"'!B4:B13),"DEANS",Indirect(""'&1&"'!H4:H13"))) What I've been...