excel formula help

double_dutchy

...how could I check for shopping and Petrol?

Try this version

=SUM(SUMIFS(D:D,C:C,{"Shopping","Petrol"},A:A,">="&E1,A:A,"<="&E2))

Vitor

>This is a bit like a voice in the wilderness....<

Yep, the OP is needing to move on from ever more complex filtering formula.

Heedtheadvice

Have sent you a pm John with an example.

outtatune

Ignore the people posting ridiculously complex filtering and summing formulae.
Use a pivot table. This kind of scenario is exactly what pivot tables were designed to address.

JohnSwift10

outtatune said:

Ignore the people posting ridiculously complex filtering and summing formulae.
Use a pivot table. This kind of scenario is exactly what pivot tables were designed to address.

The ridiculously complex filtering and summing formulae are doing what I want, all I need to do now is to figure out why Santander didn't give me cashback on a £11.75 purchase from Asda yet the same purchase the week before did give me cashback.

Doshwaster

outtatune said:

Ignore the people posting ridiculously complex filtering and summing formulae.
Use a pivot table. This kind of scenario is exactly what pivot tables were designed to address.

Pivot tables may sound scary but they really are one of the most useful and powerful features of Excel. They take a little bit of effort initially to understand how they work but once you have got the knack of them they are really easy to use and you can impress everyone with your advanced Excel knowledge.

Heedtheadvice

To be fair, although I was pushing pivot tables, John had the answers he desired.

Hopefully though pivots will be investigated...?