Error Check by Total Match

**drp99246** · 09-25-2017, 09:12 AM

Hi All,

Day Greetings,

I want to do error check with totals of data, example sheet is in attachment, all numerical figures are need to feed manually so facing error in totals at the end.

Any Suggestions are highly appreciated.

**davesexcel** · 09-25-2017, 09:30 AM

This could be a very basic question, but in B2 you would have

Formula:

Please Login or Register  to view this content.

b3 would be

Formula:

Please Login or Register  to view this content.

**drp99246** · 09-25-2017, 09:35 AM

Hi,

Thanks for prompt reply by given formula can total the figure but as per attachment i want to cross check the total.
I want to match the Total sale with online sale and Delivery sale's total.

Error Check by Total Match

LinkBack

Thread Tools

Rate This Thread

Display

Error Check by Total Match

Re: Error Check by Total Match

Re: Error Check by Total Match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Cross Check Columns for Index Match Match

[SOLVED] Using Index & Match (or similar) to check two columns for a match

copy selected rows(Check boxes) & Auto insert Sub Total & Grand Total option with Formula

Index Match Match with rank check

Pivot Table Total doesn't match data total

I thought this would be easy (check for text, check error, do math)

VBA to Check List of URLs -- Check if landing page renders a particular error message.

Bookmarks

Bookmarks

Posting Permissions