problem in countifs formula

Originally Posted by Richard Buttrey

Hi,

=SUMPRODUCT((B2:B11="Monday")*(C2:F11="tea"))

seems to work.

Thanks Richard Buttrey....it worked.

Originally Posted by Richard Buttrey

Indeed it did! I presume you spotted the typo - row 11 rather than row 21?

it's ok.....
can i use this formula for calculating from sheet1 to sheet2 ? i mean data from sheet1 and result in sheet2. if possible....how?

Originally Posted by Richard Buttrey

Hi,

Yes just preface the ranges with the relevant sheet ref. i.e.

=SUMPRODUCT((Sheet1!B2:B21="Monday")*(Sheet1!C2:F21="tea"))

thanks Richard....