SUMIF with two criteria

[Rodrigues]

Hi there
I'm looking for a formula (samples on sheet1 C6 to C10), to sum how many cells on sheet2 column L have a date (this week, 1week, 2weeks,etc) based on column E (countries).
The formulas on file attached works fine only with one criteria.
Any help will be appreciated.
Thanks in advance
Regards
R

 

[Hui]

Rodrigues

It is unclear exactly what you are after in your sample

Have you tried the Sumifs() function or Sumproduct() functions
they can both handle Multiple Conditional sumations

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[Rodrigues]

Hui,Narayan
Thank you for your prompt reply.

@Narayan
I need the opposite, if possible.
This week - Australia/Brazil how many cells on deadline column
in 1 week time - Australia/Brazil how many cells on deadline column
in 2 weeks time- Australia/Brazil how many cells on deadline column


Tried to set Countries at the beginning of the formula without success.
Thanks again
R

 

[NARAYANK991]

Hi ,

What is meant by this ?

This week - Australia/Brazil how many cells on deadline column
in 1 week time - Australia/Brazil how many cells on deadline column
in 2 weeks time- Australia/Brazil how many cells on deadline column

Can you upload your workbook after you have manually entered the required outputs , so that we can verify the correctness of the formula with the manually entered outputs ?

Narayan

 

[Rodrigues]

File attached
Thanks
R

 

[Hui]

I would use Countifs as shown in the pink cells
Note that the First week and 4 weeks+ use different formulas to the rest, which all use the same formula

 

[Rodrigues]

Thank you Hui
Very much appreciated.
Regards
R