• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMIFS Formula not working

Status
Not open for further replies.
Hi team,
In my Worksheet im trying to get data automatically in sheet2 by using sumifs formula but instead of getting the right result im getting something else.
Please rectify where im getting wrong?
Sheet1 as original data
I want data automatically in sheet 2 such as data should be split as per currency INR and USD with invoice base , invoice tax and invoice total and count of invoices as per status(Workflow not intiated ,All unpaid invoices , All paid invoices etc..)

I had resoultion sheet also how i want the data ????
 

Attachments

Status
Not open for further replies.
Top