need help building out a count & Sum with multiple criteria

[satyanarayana]

Hello,

I am building a report and it requires out put based on multiple criteria (Month, Engine, Account, Domain) and display the out put by count and sum. here I am attaching the worksheet. Please help me out to display the out put in output sheet.

Thanks,
Satya

[Kyle123]

You just need a Pivot Table

[satyanarayana]

Thanks for the quick turnaround Kyle123. Cant we do the same with COUNTIFS/COUNTIF & SUMIFS function formulas?

[Kyle123]

If you like

[satyanarayana]

I required the out put with COUNTIFS/COUNTIF & SUMIFS function formulas or any other except vlookup

[Kyle123]

Why bother? It's more error prone, processor intensive and a pain to update