Forum Discussion
Need help on a sumif formula using multiple sheets
I need a formula to compare column c in 3 different sheets and then if they equal a specific date in column c then add the values which are located in column d? Can I do this with one formula? I was ...
Thank you so much, a bit over my head but worked like a charm so really appreciate the quick response.
You're welcome.
FWIW, if you're uncomfortable with the complex nature of the formula then, assuming you'll only ever have 3 sheets, you could always write 3 separate SUMIF formulas - one for each sheet - and then sum these results.
The formula I gave you really comes into its own when the number of sheets is quite high, and so summing multiple separate SUMIF formulas becomes a touch unwieldy.
Your call.
Cheers