Hi,

I am an amateur and self-taught excel user.
My needs are easily met by excel formulae of sum, sumproduct, sumif and sumifs.
However, in my latest worksheet (which will eventually run into a million rows) I have found that my sumifs formula does not work beyond row 55000.
Help!!!

=SUMIFS(Catalogue!$E$3:$E$55000,Catalogue!$C$3:$C$55000,GrdnAvg!A19,Catalogue!$K$3:$K$55000,"Leaf")

Surajit Phukan
Assam, India