Seller totals SUMIF

[makinmomb]

Formula on F2 to drag right and down

[makinmomb]

The file is this , also want formula to increment date to upto month end

[makinmomb]

how much total has each seller date wise is the motto of the formula

[makinmomb]

Not interested in PIVOT , I know how pivot works

[popipipo]

=sumifs($c$2:$c$100;$a$2:$a$100;$e2;$b$2:$b$100;f$1)

[makinmomb]

Not working

[makinmomb]

Give open range of data as will paste more data

[JohnTopley]

Formula given works perfectly.

[makinmomb]

Someone please return the file with the formula working , my end the formula is the working

[bebo021999]

Have you tried to expand the range, 100 to, .i.e, 1000?

Why should you not to return your file with formula?

[makinmomb]

Here is the file i realised the formula had error because of the comma

Though it now works with totaling seller 1 only

[makinmomb]

I have used

Please Login or Register  to view this content.

[bebo021999]

Try to nail the column reference with $

=SUMIFS($C:$C,$A:$A,$E2,$B:$B,F$1)

[makinmomb]

Okay bebo021999
I am sorted
Thank you