chiranjiv poojari
Member
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 ????
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 ????