Sumif value with several criteria but the table is not align

[Bulugoy]

Hi all Experts/Masters,

Appreciate if someone can help me on the query below. I am also thanking advance those who will help.

Good day I need your kind help as I want to sumifs the value in column D, with criterias as follows:

1) that End Date (column I) should only be less than 30days (End Date less Report Generated )
2) Specified type ex... "BORROW RPHT,.... BORROW TERM also part of criteria
3) lastly the currency whether it is under USD/EUR etc...

Can a formula for this 3 criterias be combine together????

 

[awoohaw]

hi there. YOu can be a big help in helping the forum get you a solution if you provide your question with a mini excel worksheet using the xl2bb add in (link below).
Images, while helpful do not easily provide the forum with a convenient method of creating your scenario. The forum needs to manually create the scenario which takes a lot of time and is subject errors and typos.

Please sanitize your data before posting.

If you are unable to use the add in, the please post as a table, but you would need to provide the formulas you are using as well. And provide column letter and row numbers.

In either case, some expected results should be provided as well.

Thanks in advance.

 

[awoohaw]

also,as I look at this it seems more like a report instead of data. Do you have access to the original source where the data is on each row?

 

[Bulugoy]

hi there. YOu can be a big help in helping the forum get you a solution if you provide your question with a mini excel worksheet using the xl2bb add in (link below).
Images, while helpful do not easily provide the forum with a convenient method of creating your scenario. The forum needs to manually create the scenario which takes a lot of time and is subject errors and typos.

Please sanitize your data before posting.

If you are unable to use the add in, the please post as a table, but you would need to provide the formulas you are using as well. And provide column letter and row numbers.

In either case, some expected results should be provided as well.

Thanks in advance.

thanks I will do first you suggestion and revert back to the mini excel...appreciate your kind views/notes