P
PhilScratchingmyhead
On my spreadsheet I have info from more than one column filtered that I want
to add together onto another worksheet e.g if something in column 'A' = what
I want - then I want it to check if something in column 'B'= something else I
want...then if both criteria are met I want it to add data from column 'C'
onto another sheet. I have used sumif function but it only lets me check one
column and it's criteria but doesn't let me check the second column and it's
criteria before adding.
Any help would be appreciated as everyone here is stck in the dark ages and
were like Excel....huh????
Ta
P.
to add together onto another worksheet e.g if something in column 'A' = what
I want - then I want it to check if something in column 'B'= something else I
want...then if both criteria are met I want it to add data from column 'C'
onto another sheet. I have used sumif function but it only lets me check one
column and it's criteria but doesn't let me check the second column and it's
criteria before adding.
Any help would be appreciated as everyone here is stck in the dark ages and
were like Excel....huh????
Ta
P.