countifs across multiple tabs

[superchew]

is there a simple formulat to do a countif across multiple tabs between two dates

[Richard Buttrey]

Hi,

Without seeing your layout it's difficult to determine the best way but one way would be to include countif summaries on each tab in the same cell and then use

SUM(Start:End!A1)

function where Start and End are the first and last tab names.

[FDibbins]

Or perhaps see if you can adapt this for what you want?

=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{2,3,4}&"'!C5:P5"),"your criteria"))